View Single Post
  #1  
Old 20th June 2006, 16:43
arsen.gushin arsen.gushin is offline
Junior Member
 
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote
Sponsored Links