[RESOLVED] change mysql time zone with php

[1042]

Hello, i have this code that displays the date from a mysql timestamp, when displaying shows the mysql server time but not my local time, how can i substract 2 hours from this code to show the correct time?

<?

include("inc/staffdirectory.php");//include the file to connect to the database

$getnews = mysql_query("SELECT staff_update FROM users ORDER BY staff_update DESC LIMIT 1");//query the database for all of the news



while($r=mysql_fetch_array($getnews)){//while there are rows in the table

extract($r);//remove the $r so its just $variable

$date_time = "$staff_update";

if (($timestamp = strtotime($date_time)) === -1) {
   echo "The string ($date_time) is bogus";
} else {
   echo "Staff Directory was last updated on " . date('l F dS, Y h:i A ', $timestamp);
} 

}

?>

thank you to all in advance.

[jernhenrik]

echo "Staff Directory was last updated on " . date('l F dS, Y h:i A ', $timestamp - (3600*2));

or perhaps

mySQLs CONVERT_TZ() if you wish to do it at extraction time.

Might help you out.

hth

[1042]

jernhenrik wrote:

echo "Staff Directory was last updated on " . date('l F dS, Y h:i A ', $timestamp - (3600*2));

or perhaps

mySQLs CONVERT_TZ() if you wish to do it at extraction time.

Might help you out.

hth

Thanks jernhenrik, both ways work fine! thanks for your help 🙂