From e1ae72f14cf75aa44f81481024f511aee37d3aa0 Mon Sep 17 00:00:00 2001 From: thomasb Date: Mon, 9 May 2011 21:20:08 +0000 Subject: Rely on mysql server timezone not on PHP git-svn-id: https://svn.roundcube.net/trunk@4746 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/program/include/rcube_mdb2.php | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'roundcubemail/program/include') diff --git a/roundcubemail/program/include/rcube_mdb2.php b/roundcubemail/program/include/rcube_mdb2.php index b25938bf8..365832806 100644 --- a/roundcubemail/program/include/rcube_mdb2.php +++ b/roundcubemail/program/include/rcube_mdb2.php @@ -574,7 +574,12 @@ class rcube_mdb2 */ function fromunixtime($timestamp) { - return date("'Y-m-d H:i:s'", $timestamp); + switch ($this->db_provider) { + case 'mysql': + return 'FROM_UNIXTIME(' . intval($timestamp) . ')'; + default: + return date("'Y-m-d H:i:s'", $timestamp); + } } -- cgit v1.2.3