mysql time problem

Discussion in 'MySQL' started by dizyn, Sep 9, 2008.

0
  1. #1
    I am having time problem with mysql when i do:
    SELECT now() as now;
    Code (markup):
    2008-09-09 05:26:40

    But server time is : 15:26:40 2008

    why is this? any help?

    thank you
     
    dizyn, Sep 9, 2008 IP
  2. drunnells

    drunnells Peon

    Messages:
    79
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Just a guess, but maybe the wrong timezone has been configured? Take a look here:
    http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html

    If not, what timezone are you in? And if this is linux/unix, from a shell, what is the exact output of?:

    date
    Code (markup):
     
    drunnells, Sep 9, 2008 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    You might have change system time after starting mysql. In this case, simply restart mysql and check again.
     
    mwasif, Sep 10, 2008 IP