[dex002]

Is there a way to adjust the time so that mysql timestamp displays a relative time instead of the server time?

I want my timestamps to be in Eastern Standard Time but my server stamps in Western Time (about 2hrs before). Is the a way around this so the time stamp is correct, or should I just try an add a couple of hours to the results query?

Either way, I don't know how to do it. Cheers, Dex.

[eq1987]

I really don't use programming talk much anymore, as i found Sitepoint - so i may not respond again.

It is possible and info about time can be found at http://us2.php.net/date

If you can't understand what they are talking about, you can reply & I might see this post again.

[infinitylimit]

if you are sure it's 2 hours before just subtract off of the results query.

Timestamps are in seconds since the unix epoch 1970.

Your could we be something like this

PHP Code:

$result = mysql_query('SELECT timestamp FROM table');

$relative_time = mysql_result($result,0,0) - (60*60*2);