tomhoad Posted March 5, 2008 Share Posted March 5, 2008 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> ' ); } ?> Link to comment https://forums.phpfreaks.com/topic/94595-unixtime-in-gmt/ Share on other sites More sharing options...
kenchucky Posted March 5, 2008 Share Posted March 5, 2008 Where you have FROM_UNIXTIME(date Add -21600 after "date" to subtract 6 hours, or +21600 to add 6. Link to comment https://forums.phpfreaks.com/topic/94595-unixtime-in-gmt/#findComment-484372 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.