Win a copy of Getting started with Java programming language this week in the Beginning Java forum!
  • 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
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!