Hello, i guess your question has been answered.
I use this function ( from model) to convert any type of timestamp to the user date-time
PHP Code:
function _set_timestamp($timestamp)
{
$timezone = $this->input->cookie('_timezone');
$dt = new DateTime();
$dt->setTimezone(new DateTimeZone($timezone));
$dt->setTimestamp(strtotime($timestamp));
return $dt->format("H:i d-m-Y");
}
so i take the server timestamp and the user timezone ( i have it on cookie) and i return the correct time according to user timezone
So i just keep the server timestamp+Database Timestamp the same and i just change the users.