From 44653321b407edc2334a9ec1e1e46a0a03201646 Mon Sep 17 00:00:00 2001 From: alecpl Date: Fri, 31 Jul 2009 06:45:50 +0000 Subject: - Fix rcube_mdb2::unixtimestamp for MS SQL (#1486015) --- program/include/rcube_mdb2.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'program/include') diff --git a/program/include/rcube_mdb2.php b/program/include/rcube_mdb2.php index 86d798a79..610aaf50a 100644 --- a/program/include/rcube_mdb2.php +++ b/program/include/rcube_mdb2.php @@ -507,7 +507,7 @@ class rcube_mdb2 break; case 'mssql': - return "datediff(s, '1970-01-01 00:00:00', $field)"; + return "DATEDIFF(second, '19700101', $field) + DATEDIFF(second, GETDATE(), GETUTCDATE())"; default: return "UNIX_TIMESTAMP($field)"; -- cgit v1.2.3