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?
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.