How do I change the timezone in mysql?

Discussion in 'MySQL' started by Imozeb, Jun 1, 2010.

0
  1. #1
    How do I change the timezone in my mysql database via phpmyadmin?
     
    Imozeb, Jun 1, 2010 IP
  2. Imozeb

    Imozeb Peon

    Messages:
    666
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Is it even possible? If not could you guys tell me how to tell the timezone of my database so I can sync it with PHP?
     
    Imozeb, Jun 2, 2010 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    Have you tried running something like this:

    SET time_zone = 'US/Eastern';
     
    jestep, Jun 2, 2010 IP