From: Eric Bergen Date: September 27 2004 9:09pm Subject: Re: server timezone and system timezon List-Archive: http://lists.mysql.com/mysql/173276 Message-Id: <11b1bd9904092714097cd7295b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Have the location selecting adjust the timezone when it selects. Example select t + interval 6 hour from t -- Eric Bergen eric.bergen@stripped On Mon, 27 Sep 2004 12:24:36 -0600, Elim Qiu wrote: > 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. >