Change time in PHP

[forumnz]

Hey! I have dates in my database (datetime) like 2009-04-30 20:45:45. This is fine, however the time is 17 hours behind the time in my country.. how can I easily modify this each time I retrieve these dates from the database?

 

Thanks

Sam

[Masna]

I'm not sure how to do it with DATETIME format, but you can do it very easily if you store a UNIX timestamp instead:

 

$timestamp = {retrieve timestamp from MySQL database here};
$timestamp += (60*60*17);