This week's giveaway is in the Java/Jakarta EE forum.
We're giving away four copies of Java EE 8 High Performance and have Romain Manni-Bucau on-line!
See welcome thread
Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE 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!