>>>>>Does anyone know how to group a result set on just the date portion of a datetime column using SQL pass-through?
>>>>
>>>>Just select one more column: datepart as date(datetime field) and group on this column.
>>>>
>>>>Vlad
>>>
>>>The DatePart function in MS SQL server doesn't allow you to return the entire date portion. I would have to concatenate the year, month and day portions and I'm hoping to avoid that.
>>
>>I don't know MSSQL. Are you using VFP? How do you access the SQL database? Via ODBC?
>>
>>If yes, you should be able to use date( your_datetime_field) which should return the date part of datetime field.
>>
>>Vlad
>
>With SQL passthrough, the date function will only work if it is supported by the backend server.
Just wondering if you found a solution to this without having to
concatenate the year, month, and day?
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