MySQL timezone question

For our public website we have a hosted MySQL database through a third =
party. The server is hosted in the eastern united states, so the =
TIMESTAMP columns are populated with EST. We would like to have the =
timestamp columns have GMT regardless of where the server is located. We =
do not have access to MySQL at the system level. Is there any work =
arounds so that we record Time according to GMT regardless of where the =
MySQL server is hosted from?

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: MySQL timezone question

Yes...

11.3.1.1. TIMESTAMP Properties as of MySQL 4.1
You can set the current time zone on a per-connection basis, as
described in Section 5.11.8, "MySQL Server Time Zone Support". TIMESTAMP
values are stored in UTC, being converted from the current time zone for
storage, and converted back to the current time zone upon retrieval. As
long as the time zone setting remains constant, you get back the same
value you store. If you store a TIMESTAMP value, and then change the
time zone and retrieve the value, the retrieved value is different than
the value you stored. This occurs because the same time zone was not
used for conversion in both directions. The current time zone is
available as the value of the time_zone system variable.=20

Ed
=20

-----Original Message-----
From: James Frankman [mailto:jfrankman@idfbins.com]=20
Sent: Thursday, March 23, 2006 1:10 PM
To: win32@lists.mysql.com
Subject: MySQL timezone question

For our public website we have a hosted MySQL database through a third
party. The server is hosted in the eastern united states, so the
TIMESTAMP columns are populated with EST. We would like to have the
timestamp columns have GMT regardless of where the server is located. We
do not have access to MySQL at the system level. Is there any work
arounds so that we record Time according to GMT regardless of where the
MySQL server is hosted from?

--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=3Demierzwa@micron.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org