Time problem

Discussion in 'Databases' started by dizyn, May 18, 2010.

  1. #1
    Hi,

    My server is based in USA and it's mysql database time is EST. It's a shared server and i cannot change it's time. I don't want to use EST infact i want to use GMT + 5 time.

    for example i save something in database and timestamp saved current timestamp that's EST when i access it i want to show it in GMT+5

    How can i do that?

    thank you
     
    dizyn, May 18, 2010 IP
  2. dizyn

    dizyn Active Member

    Messages:
    251
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Solution:

    mysql_query("SET time_zone = '+5:00'") or die();
     
    dizyn, May 18, 2010 IP
  3. itsupportservice

    itsupportservice Peon

    Messages:
    93
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for giving the important time solution.... Because many people facing this type of problems...!!
     
    itsupportservice, May 20, 2010 IP