I am still having problems with the time zone within Mysql. I change the value of the TZ environment variable, and that change will show up in the SHOW VARIABLES; query within mysql, but the actual time that is being provided by the select now(); is still not showing up correctly.
Please Help!!! Thanks -----Original Message----- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 8:48 AM To: [EMAIL PROTECTED] Subject: Re: Mysql time zone problem Scott, Monday, April 29, 2002, 1:46:09 AM, you wrote: SS> I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2 SS> box, so the select now(); query returns the correct time. The show variable SS> command show that the time zone is being updated with the different values I SS> enter, but the time is still coming up 4 hours off. I am trying to set it SS> to US - Central. I have tried entries for :US/Central, Central, SS> America/Central, and America/Chicago, but none of these have worked. Scott, look at your /usr/share/zoneinfo dir. You can find there all available timozones. You can also set timezone using GMT, for example --timezone=Etc/GMT+2 SS> Thanks in advance for your suggestion. SS> Scott -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
