Register / Login
JDBC and Relational Databases
Converting float value to smalldatetime is giving future date
posted 1 month ago
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 --
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 this discrepancy reading the mdf file.
Boost this thread!
to convert timestamp into date and time
Having a JTable Selection.
javax.jms.JMSSecurityException: User null is NOT authenticated
CMP and Oracle CLOB