Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error retrieving datetime from SQL
Message
 
 
À
04/03/2010 11:13:34
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Application:
Desktop
Divers
Thread ID:
01452511
Message ID:
01452516
Vues:
39
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform