Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up? I have read the manual on this, and tried various combinations, but haven't hit the right syntax.
Gerald Jensen ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 8:14 AM Subject: Re: TZ setting DL, Wednesday, April 17, 2002, 1:37:15 PM, you wrote: DN> Manual References: A.4.6 Time Zone Problems, F Environment Variables, DN> and 4.1.2 my.cnf Option Files, but no examples or real explanation of DN> use. DN> Has anyone made use of MySQL's TZ setting? DN> Can the TZ setting be used to run a db in a different time zone to the DN> underlying OpSys? Run mysqld with --timezone=# option ... Look at: # mysqld_safe --timezone=EET & mysql> select now(); +---------------------+ | now() | +---------------------+ | 2002-04-17 12:59:06 | +---------------------+ 1 row in set (0.01 sec) # mysqld_safe --timezone=GMT & mysql> select now(); +---------------------+ | now() | +---------------------+ | 2002-04-17 10:01:38 | +---------------------+ 1 row in set (0.00 sec) DN> (Windows and/or Linux) DN> Please advise, DN> =dn -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
