April 8th, 2004, 04:37 AM
|
|
Contributing User
|
|
Join Date: Nov 2003
Posts: 51
Time spent in forums: 1 h 30 m 29 sec
Reputation Power: 5
|
|
|
Incorrect datetime settings on SQL Server 2K.
Hi,
Ok ive been running a classic ASP application locally and i've been using:
session.lcid=2057 to format my dates to uk time (DD/MM/YYYY HH:MM:SS). This works fine on my local machine however when I upload it to the server it comes out as MM/DD/YYYY HH:MM:SS even with this option enabled.
Im running SQL server 2000.
What's weird is if i return the current web server time just by using the now() function it displays it correctly...
But if I try to input the server time using an UPDATE statement into a datetime field, it formats it incorrectly. This is only on the web server, on my local machine it works fine.
Could it be something to do with the datetime settings on the server?
I have checked the timezone settings on the web server and they are set to the UK.
Any help or suggestions appreciated.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
