• Post Reply Bookmark Topic Watch Topic
  • New Topic

Converting float value to smalldatetime is giving future date  RSS feed

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.

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!