Hi, I'm looking for help on timezone issues. I'm using mysql for a web application about time related events. I've two servers in different locations with different timezones.
How to setup the database server so that the datetime value will not depend on the server machine's timezone? In other words, how to make the datetime value of the same record fetched from both mysql servers unaffected by locations? Thanks for any helps.