On Tue, May 13, 2008 at 2:07 PM, Ed W <lists@wildgooses.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
wultsch@gmail.com
wultsch (aim)