List:General Discussion« Previous MessageNext Message »
From:Gerald R. Jensen Date:April 17 2002 10:52pm
Subject:Re: TZ setting
View as plain text  
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




Thread
TZ settingDL Neil17 Apr
  • Re: TZ settingVictoria Reznichenko17 Apr
  • Re: TZ settingGerald R. Jensen18 Apr