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" <victoria.reznichenko@stripped>
To: <mysql@stripped>
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
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ 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 <mysql-thread106374@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-autodata=execpc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
