Time problem

Databases
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

2

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

3

Solution:

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

4

and also on where you are

5

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.