Hmmm - pardon me for jumping in in a conversation in progress - but according to the manual* you should be able to set the TZ variable to your timezone - which sounds like what has happened on your machine.
If you can figure out how to put the right code in, your SQL queries will purportedly be in GMT. I would try safe_mysqld --timezone=0 Or safe_mysqld --timezone=GMT I'm trying to figure out something similar (see my post below) - so let me know if you find anything.... 'deep *http://www.mysql.com/doc/s/a/safe_mysqld.html & http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html ---------my post ---------------- Hi folks - I am having 2 related problems with the timezone setting for mysqld & was hoping to get some help. Basically my squestions are as follows: a) the documentation says to set timezone by simply using --timezone=# when starting mysqld - but WHAT are the valid number values & which time zones do the map to? b) I have tried to set the timezone using "safe_mysqld --timezone=XX" where I have tried various values for XX such as o1, 1, 13, 05,08 BUT near as I can tell ANY value I put in gives me GMT/UTC time (I think that's what it is) rather than giving me time offset by the given amount i entered. This is not what the documentation seems to suggest will happen - or am I being obtuse? Any help or suggestions would be appreciated. ---------------------------------- Amandeep Jawa Worker Bee Software ---------------------------------- [EMAIL PROTECTED] 225A Dolores St. San Francisco, CA 94103-2202 Home: 415 255 6257 (ALL MALP) professional: http://www.worker-bee.com personal: http://www.deeptrouble.com political: http://www.sflcv.org > From: "DL Neil" <[EMAIL PROTECTED]> > Reply-To: "DL Neil" <[EMAIL PROTECTED]> > Date: Tue, 5 Feb 2002 00:35:28 -0000 > To: <[EMAIL PROTECTED]>, "Oliver Mannion" <[EMAIL PROTECTED]> > Subject: Re: Obtaining GMT time in mySQL > > Hi Oliver, > >> I would like to obtain the time in GMT in mySQL. >> >> CURRENT_TIMESTAMP returns the local time >> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on >> my system >> >> But how can I get the time in GMT??? > > > MySQL is time-neutral, that is to say, if you ask it the time, it will ask the > server OpSys. > > As my mother used to say, "you only get out of something, what you put into > it"! If you declare a date/time > column, any data you INSERT will have the same value when you subsequently > SELECT it. It's up to you to > determine which time zone to use when representing your data. > > Are you accessing MySQL from some other facility, eg PHP? Can you use that > tool to acquire/restate the temporal > data? > > Regards, > =dn > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php