MySQL time differs from system

Discussion in 'Server Operation' started by arsen.gushin, Jun 20, 2006.

  1. arsen.gushin

    arsen.gushin New Member

    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?
     
  2. sjau

    sjau Local Meanie

    does EDT have daylight savings?
     
  3. arsen.gushin

    arsen.gushin New Member

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

    sjau Local Meanie

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

    arsen.gushin New Member

    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.
     
  6. sjau

    sjau Local Meanie

    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.
     
  7. falko

    falko Super Moderator

    You can try to adjust the time zone settings with
    Code:
    tzconfig
     
  8. arsen.gushin

    arsen.gushin New Member

    ok, thank you.
    i will try it.
     

Share This Page