>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement