Hi, can anyone explain mysql 5.0.54 handling of replication between two
servers with inconstant /etc/localtime (but the same real clock time for
UTC)
On one server I inserted a new row with "created_at" and "updated_at" as
the same time. Server localtime is GMT+1, created col is a date,
updated_at col is a timestamp
When this replicated to the other server which had localtime set to GMT,
and then after it replicated I changed localtime to GMT+1 I find that
created_at is no longer the same as updated_at - now updated_at is 1
hour later...
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?
Thanks
Ed W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
