You can map datetime field to a date in a view so I don't see a difference between date and datetime as long as data is accesed through a view or CA. The ttod(datetimefield) = ? vp_Date in the WHERE clause doesn't translates nicely to SQL Server, though.


>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?