• Post Reply Bookmark Topic Watch Topic
  • New Topic

Converting float value to smalldatetime is giving future date  RSS feed

 
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!