Time problem


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

Don’t forget about daylight savings time. The difference alternates between -4 and -5 depending on the time of year.


mysql_query(“SET time_zone = ‘+5:00’”) or die();

and also on where you are

EST = GMT - 5
your time = GMT + 5

your time = EST + 10

So you could add 10 hours to the timestamp you get from your database.