Have the location selecting adjust the timezone when it selects. Example select t + interval 6 hour from t
-- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep 2004 12:24:36 -0600, Elim Qiu <[EMAIL PROTECTED]> 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. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
