Hello,

I have trouble working with Date fields in SQL Server 2008. when I use Date type, it returns as Character(8) in queries. So I need to use datetime fields, but obviously the program should not display the time part of the datetime field. Has somebody found a good practice to work around this issue?