>>Hi everybody,
>>
>>We had a discussion today about date vs. datetime field and I want to get your valuable input.
>>
>>We currently use Visual FoxPro native data as our back end but we may go to SQL Server in the future. Is it wise to have all date fields defined as datetime and therefore use ttod(datetimefield) = ? vp_Date in our p-views and index on ttod(datetimefield)? Or should we use date field if there is no sense in datetime field from the user's perspective?
>>
>>Also I think I read it here recently that SQL Server is going to introduce DATE field. Is it a rumor I'm just starting or a fact?
>>
>>Thanks a lot in advance for your help.
>
>Dont worry in new SQLServer2005 there is Date type field

As I understood, there is no confirmation about it from MS. Here is the link
http://www.microsoft.com/technet/prodtechnol/sql/2005/maintain/sqlydba.mspx#EEAA see the Appendix for new field types.