Announcement

Announcement Module
Collapse
No announcement yet.

TimeZone Question

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • TimeZone Question

    Hi,

    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?

    Regards

  • #2
    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 -

    Comment

    Working...
    X