>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only