OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Timestamps replicating inconsistently depending on local timezone of server?

From: Rob Wultsch (wultschgmail.com)
Date: Tue May 13 2008 - 19:02:40 CDT

On Tue, May 13, 2008 at 2:07 PM, Ed W <listswildgooses.com> wrote:
> I had naively assumed that dates would always be stored in UTC in the
> database and the only effect of localtime would be for display purposes?
> Can anyone shed some light on what's happening here please?

"TIMESTAMP values are converted from the current time zone to UTC for
storage, and converted back from UTC to the current time zone for
retrieval. (This occurs only for the TIMESTAMP data type, not for
other types such as DATETIME.)"

http://dev.mysql.com/doc/refman/5.1/en/timestamp.html

--
Rob Wultsch
wultschgmail.com
wultsch (aim)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql