[RESOLVED] Adding hours to timestamp

rlalande

Hi,

I have a database table with a field named "time", and when someone adds a record to the table, that field is updated with the current server time.

Here's an example of the value in that field: 2007-11-12 10:26:43

The server is 3 hours behind my time, so I just want to be able to add 3 hours to that time when I access that value from my php page.

How do I do that?

Thanks

Rock

sandthipe

If it was my site, I would try these 3 things (in order of preference)
1. change the timezone on the server (if I had access)
2. change the date.timezone option in php.ini
3. use ini_set to change the timezone (if no access to php.ini)

you can find a list of supported timezones here:
http://us2.php.net/manual/en/timezones.php

to use the ini_set function, just include this at the top of each php file that needs the proper timezone (or better yet, put it in a separate file and include that file in each php file on your site)

ini_set("date.timezone","America/Detroit");

obviously "America/Detroit" is an example. consult the link above for the right value for your timezone.

rlalande

Not really what I'm looking for... timezones are in php 5.0, my ISP is running 4.something.

And I don't have access to php.ini or the server.

There must be a way to convert the timestamp string to a value, add 3 hours, and then convert it back to a string I can display on that page?

ddconcepts

I prefer to save timestamp in its original numerical 10 digits form.
Then add 3 hours, which is 10800 seconds.

$timenow = time();
$newtime = $timenow+10800;

When you retreive the value to can convert timestamp to display any way you want.

NogDog

echo strtotime($timeString . ' + 3 hours');

Alternatively, you could have it adjusted in your query:

SELECT DATE_ADD(`time`, INTERVAL 3 HOUR) AS `adjusted_time` . . .

rlalande

Thanks for the input.

Got it to work like I wanted with this:

$time = strtotime($row[time] . ' + 3 hours');
$time = date("m/d/y - h:i a", $time);

echo $time;