>>ADS has a Time datatype, which is internally stored as the number of milliseconds since midnight in a 4-byte integer.
>
>OK the same query, but you should find the right functions for converting:
>
>SELECT YourTable.*;
> FROM YourTable;
>INNER JOIN (SELECT Sh, MAX(ConvertDateToISO(DateSaved)+' '+ConvertTimeToString(TimeSaved)) AS DateTimeSaved;
> FROM YourTable;
> GROUP BY Sh) Tbl1;
>ON YourTable.Sh = Tbl1.Sh AND;
> ConvertDateToISO(YourTable.DateSaved)+' '+ConvertTimeToString(YourTable.TimeSaved) = Tbl1.DateTimeSaved
>
>
>Where ConvertDateToISO() should convert your Date to string with folwong format "YYYYMMDD" and
> ConvertTimeToString() should convert Time to string no matter what format it is, just make sure that 12:01 PM is bigger than 12:01 AM it could be:
>"18:20", "1820", "66000" (that is 18*3600 + 20*60)
Hi Borislav,
Please check my suggestion. It may be slower, but no conversions are needed. First we filter the maximum date, then the maximum time for that date.
If it's not broken, fix it until it is.
My Blog