Win a copy of OCP Java SE 8 Programmer II Exam Study Guide this week in the OCP forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Converting float value to smalldatetime is giving future date  RSS feed

Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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;

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

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.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!