Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Converting float value to smalldatetime is giving future date

Benarjee Gorikapudi
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.

What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!