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 15: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 19:23

does EDT have daylight savings?

arsen.gushin

20th June 2006 23:13

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

sjau	20th June 2006 23:52

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

arsen.gushin

21st June 2006 08: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 09: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 20:24

You can try to adjust the time zone settings with

Code:

tzconfig

arsen.gushin

23rd June 2006 19:33

ok, thank you.
i will try it.

All times are GMT +2. The time now is 00:50.