Default timezone set

[lukep11a]

Hi, I am trying to get the date and time that a particular table was last updated, which the code below does, but it doesn't seem to be putting it in the correct timezone, it is 5 hours behind, anyone know why this is? or how i can fix it? Thanks

 

<?php
	date_default_timezone_set('Europe/London');
        $query = "SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'tffdb' AND TABLE_NAME = 'test_team_points'";
        $result = mysql_query($query) or die(mysql_error());
        
        $row = mysql_fetch_assoc($result);
	echo $row['UPDATE_TIME'];

?>

[phporcaffeine]

Well, the time that the table was last updated, should be recorded in the time / timezone that is set on the server that MySQL is running on.

 

So what are you trying to do? Are you trying to fetch the time and then apply a UTC offset to translate the time into another timezone?

[lukep11a]

Yes I am trying to translate it into the Europe/London timezone

[phporcaffeine]

I think what you're looking for is gmstrftime().

 

http://us.php.net/manual/en/function.gmstrftime.php