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?

 

does EDT have daylight savings?

 

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

 

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.

 

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.

 

You can try to adjust the time zone settings with

Code:

tzconfig

 

ok, thank you.
i will try it.