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
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Also

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.

Thanks,
Ben
 
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
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!