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