I've set up an edit column in the database, it stamps the correct time whenever a change is made to the database entry. For some odd reason whenever this datetime displays it displays 5 hours behind the time stamp in the database.
The only thing I can figure to do is add 5 hours to the time, but I can't seem to get any combinations from the online examples to simply add 5 hours to the stamp. Was hoping someone could help me out.
if ($comment->deleted == 1) { } else {
$db = JFactory::getDbo();
$db->setQuery('SELECT editdate
FROM #__jcomments
WHERE id = ' . $comment->id .'');
$db->loadResult();
$edit = $db->loadResult();
if ($edit > 0) {
echo JHtml::_('date', $edit, JText::_('l F j Y g:ia')); } }