I am trying to read a float value from an MDF file and it is always giving the future date. Meaning actual date +2
Below is my query;
Select convert(smalldatetime, max(analysis_time)) from image where patientId = 12345;
Value for analysis_time is --
The above query is returning --
2016-11-27 02:04:00 .
But when i convert the float value to date in MS Excel (format cell to date) it is giving correct date
When i read the same float value from MDB file with below query(using access driver), it is returning the correct date
Select timestamp(max(analysis_time) * 86400000 - 2209161600000) from image where patientId = 12345
As the timestamp is not a valid function in sql server i am trying use convert function to read the MDF.
Can someone help me what would have caused for this discrepancy reading the mdf file.