Linked SQL table

[GWB]

This might be a dumb question but its got me.
I have linked to a sql table via odbc and can read the table in access. The
problem is that the date time is incorrect in access - it is displayed
correctly in sql but not in access. The sql column format is Date/Time
Any help would be appreciated

Thanks

 

[KARL DEWEY]

The problem is that the date time is incorrect in access
Is the time wrong or just displayed differently than you would like?
If it is wrong then how for off is it?
It would help if you post what it is displaying and what you want for your
display.

 

[GWB]

Specifically the year is way off - it shows 1940 instead of 2010

 

[KARL DEWEY]

Access stores the date and a number counting the days from 12/30/1899
12:00:00 am and uses the decimal part of the number for storing time. One
fourth of a day, 0.25 is displayed as 6:00:00 am. December 31 1899 and one
second after midnight is 1.00001157407407.

I read somewhere the a SQL Server starts their time from 1939.

So you would need to add 14609 (or maybe it is 14610) to the SQL value.

 

[James A. Fortune]

Access stores the date and a number counting the days from 12/30/1899
...
I read somewhere the a SQL Server starts their time from 1939.

So you would need to add 14609 (or maybe it is 14610) to the SQL value.

From:

How can i compare time in SQL Server?

http://stackoverflow.com/questions/807909/how-can-i-compare-time-in-sql-server

"The 1900-01-01 is just the 'zero' date"

James A. Fortune
(e-mail address removed)