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 Moderator HowtoForge Supporter

    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 Moderator HowtoForge Supporter

    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 Moderator HowtoForge Supporter

    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 Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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