Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime fields in MSSQL as Date in VFP
Message
 
To
07/12/2009 17:44:04
Hong Yew
People Quest
Malaysia
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Re: Datetime fields in MSSQL as Date in VFP
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01437969
Message ID:
01438007
Views:
48
Using SQL Server 2008, SQL Server Native Client 10.0 and T-SQL this works for me:

select cast(datetimefield as DATE) as dateonly from mytable
Brandon Harker
Sebae Data Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform