TimeZone Question


At work I have 2 MySQL servers one for Europe(EU) and one for NorthAmerica(NA), each with it’s own timezone. Now the company wants to migrate both servers on only one in EU.

My problem is that for the databases for the original server from NA i still need to insert/update dates at their timezone. So how can i have different timezones on the same server?

Can i set a timezone for schemes or users?


There is some good documentation for timezones in the MySQL docs at:

http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.htm l

Basically, you can set the timezone on a per-connection basis (i.e., in your application) using the time_zone variable (which, of course, can be set globally, too).

Hope that helps -