Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
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.)"
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql