HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   MySQL time differs from system (http://www.howtoforge.com/forums/showthread.php?t=5033)

arsen.gushin 20th June 2006 16:43

MySQL time differs from system
 
Hi, all.

OS: Debian 3.1 Stable
mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)

shell> date
Code:

Tue Jun 20 09:36:xx EDT 2006
mysql> select now();
Code:

+---------------------+
| now()              |
+---------------------+
| 2006-06-20 08:36:xx |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT @@global.time_zone, @@session.time_zone;
Code:

+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM            | SYSTEM              |
+--------------------+---------------------+
1 row in set (0.00 sec)

So, if both global and session time_zone variables set to SYSTEM, why system and MySQL time differs?

sjau 20th June 2006 20:23

does EDT have daylight savings?

arsen.gushin 21st June 2006 00:13

i'm newbie in linux :)
how can i check it?

sjau 21st June 2006 00:52

do you have to adjust the time where you live twice a year by one hour each?

arsen.gushin 21st June 2006 09:10

Quote:

Originally Posted by sjau
do you have to adjust the time where you live twice a year by one hour each?

yes, i do have.
but server on which i have trouble described above is remote, and time zone set ot Europe/Amsterdam for it. and i don't know how to check enabled daylight savings on it or not.

sjau 21st June 2006 10:23

I was just thinking that either mysql or the system doesn't respect the daylight savings... hence you would have this 1 hour difference... but I'm not really sure on that.

falko 21st June 2006 21:24

You can try to adjust the time zone settings with
Code:

tzconfig

arsen.gushin 23rd June 2006 20:33

ok, thank you.
i will try it.


All times are GMT +2. The time now is 22:45.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.