Timestamps replicating inconsistently depending on local timezone of server?

[Ed W <lists@xxxxxxxxxxxxxx>]

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/mysql?unsub=royale@xxxxxxxxxx