>>>And because it should be SQL Server compliant try:
>>>That is of course if DateSaved is datetime field.
>>>BTW Why not just use Datetime field?
>>
>>Well I have been witholding some information :) It is not VFP and it is not SQL Server, it is ADS (Advantage Database).
>>I am stuck with a table and need to extract some data from it. I only have to do it once so I do not care if it is efficient..
>>
>>Anywho, there is a DateSaved field (not datetime, just date) and a TimeSaved field (not datetime, just time). I seem to recall that VFP also had just date and just time fields before. ADS is based on DBase like Fox was.
>>
>>Anywho I got side tracked on my quest for a query but I am hoping to get a chance to look into it this afternoon.
>
>Can you transform Date field to ISO 'yyyymmdd' style (In VFP we have DTOS() function)? and what is Time field? A regular Char of there is such type in ADS?

ADS has a Time datatype, which is internally stored as the number of milliseconds since midnight in a 4-byte integer.