summaryrefslogtreecommitdiff
path: root/program/include
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2009-07-31 06:45:50 +0000
committeralecpl <alec@alec.pl>2009-07-31 06:45:50 +0000
commit44653321b407edc2334a9ec1e1e46a0a03201646 (patch)
tree3efb7e5b664422a36f449320fcf9501443477a32 /program/include
parent793e24885b0e210c630be8a1db78e0e795c33c47 (diff)
- Fix rcube_mdb2::unixtimestamp for MS SQL (#1486015)
Diffstat (limited to 'program/include')
-rw-r--r--program/include/rcube_mdb2.php2
1 files changed, 1 insertions, 1 deletions
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)";