Wrong time inserted into MS SQL Server 2005
A strange "feature" to be sure. I've got an AIR Application I built which includes collecting the date/time for an event. When I sync my sql lite database with MSSQL Server via ColdFusion Componenets (cfc), I found the time was 2 hours ahead.
Huh??
I then realized that emails sent from this server were ALSO ahead two hours. So I went into Windows 2003 Server and changed the TIMEZONE from Central Time (2 hours ahead) to Pacific Standard Time.
The webhost had setup our dedicated server with the wrong time zone.
It took a reboot of the server for the Timezone to take effect.
Problem solved!
Recent Comments