1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Time problem

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

0
  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