UNIXTIME in GMT

[tomhoad]

My timestamps are out by six hours. How can I edit the output to adjust that difference?

 

<?php 

include 'secure/config.php'; 
include 'secure/opendb.php'; 

$query   = "SELECT id, title, content, FROM_UNIXTIME(date, '%W %D %M %Y at %h:%i %p') as dttm 
FROM news ORDER BY id DESC LIMIT 3"; 

$result  = mysql_query($query) or die('Error : ' . mysql_error()); 
while ($row     = mysql_fetch_array($result, MYSQL_ASSOC)) { 

$title   = $row['title']; 
$content   = $row['content'];
$dttm   = $row['dttm'];

echo stripslashes (
'
<p class="news-header">'.$title.'</p>
<p class="news-body">'.$content.'</p>
<p class="news-footer">Posted on: '.$dttm.'</p>
<br>
'
);    

}

?>

[kenchucky]

Where you have FROM_UNIXTIME(date

Add -21600 after "date" to subtract 6 hours, or +21600 to add 6.