Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datetime to date
Message
From
17/02/2000 13:02:00
Oleg Khvalin
The Sutherland Group Ltd
Rochester, New York, United States
 
 
To
17/02/2000 11:57:56
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00333280
Message ID:
00333527
Views:
14
>>Does anyone know how to just return the date and not the time from ms-sql server when you use sqlexec ?
>
>You can use convert... but, since Date is not a type in SQL server you would have to 'convert' it to a varchar. You could also create a cursor with the field as a date, and append your SQL cursor into the normal cursor.
>
>If you use a view you can set the field to a date type... I don't see a way to change the type after you have got the cursor.
>
>BOb
If the goal just to eliminate time portion of datetime double convert will work:
CONVERT(datetime, CONVERT(char(12), yourDateTime, 101))
but why not ttod() ?
Oleg
Previous
Reply
Map
View

Click here to load this message in the networking platform