Timezone offset?

[sidsel]

I have some mysql timestamps like "2006-07-11 19:44:10"

Is there a way to let a user show this date & time in his own local time(zone) if I know his offset to GMT/UTC?

I should point out the the original timestamps are unfortunately not in GMT/UTC time but GMT -0500

[tsinka]

Hi,

you can use strtotime to do that. strtotime allows you to add something like "+5 hours" to a date/time string:

<?PHP
    $strDateTime = date("Y-m-d H:i:s");
    $intMyOffset = -5;  // GMT-5
    $intUserOffset = 2; // GMT+2
    $intOffsetDiff = $intUserOffset-$intMyOffset; // difference

$intNewTimestamp = strtotime("$strDateTime $intOffsetDiff hours");
echo date("Y-m-d H:i:s", $intNewTimestamp);
?>

But this solution doesn't take care of DST.

Thomas

[Installer]

This will also work:

$intMyOffset = -5;  // GMT-5 
$intUserOffset = 2; // GMT+2 
$intOffsetDiff = $intUserOffset - $intMyOffset; // difference 
$intNewTimestamp = strtotime($intOffsetDiff . ' hours');
echo date("Y-m-d H:i:s", $intNewTimestamp);

[sidsel]

I would like to care of DST as well.
Would it be possible to decide if DST is 0 or 1 by using date("I", $the_original_timestamp) ?

[Installer]

date('I');

will tell you whether or not the server time is on DST.