How to set the default user timezone in a timestamp

rloyola

Is there a way to set the timezone in the query result?

Example 'DateInserted' needs to be in a user timezone.

$query = Gdn::sql();
$query->select('u.*,ur.*,r.Name as Role')->from("User u");
$query->join('UserRole ur', 'u.UserID = ur.UserID', 'inner');
$query->join('Role r', 'ur.RoleID = r.RoleID', 'inner');
$query->where('u.Banned',0);
$query->where('u.Deleted',0);
$query->OrderBy('u.DateInserted', 'desc');
$query->get()->result();

Thanks

K17

Correct me if I'm wrong but timestamp do not bother with timezone, everyone have the same timestamp for all timezones.

The timestamp is the amount of seconds since the 1st january 1970 at 00:00:00 UTC 0.

In Vanilla this timestamp is display to the user according to his own timezone (set in the "HourOffest" column of your GDN_User table).