Hex value to date time

[rxbagain]

The 4 bytes of the sql datetime is the number of days since 1900-1-1. The second 4 bytes is the miliseconds since midnight. You can convert the values like this

   int date_part = 0x00009B93;
   int time_part = <time value here> / 1000;   
   COleDateTime startOnDate(1900, 1, 1, 0, 0, 0);
   startOnDate += COleDateTimeSpan(date_part, 0, 0, time_part);
   CString buffer = startOnDate.Format();

The location of the date 0x00009B93 is ok but your time should be the next 4 bytes after the days location. Check your .mdf file and use the 4 bytes after 0x00009B93 as time.

Hope it will help