Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error retrieving datetime from SQL
Message
 
 
To
04/03/2010 11:13:34
Melvin Sequera
M&H New World, C.A.
Fuenlabrada, Spain
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01452511
Message ID:
01452516
Views:
38
>Good afternoon, right now I'm writing an app in MS Access that connects to SQL Server through ODBC.
>
>The problem that I'm having is when I retrieve the data from a datetime field, it's always 1 hour back in Access.
>
>Honestly I've think that the problem is related to some kind of config in the odbc driver setup, but I can't find the way to solve it.
>
>Thanks in advance for yout help.
>
>Melvin

Does your server and your local computer show the same date and time? In other words, when you do select getdate() from SQL Server, is it the same as your local time?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform