diff options
| author | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2009-07-31 06:45:50 +0000 |
|---|---|---|
| committer | alec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2009-07-31 06:45:50 +0000 |
| commit | dc1d443a52d8cb955922bddbe0c82ab0b3ab27cb (patch) | |
| tree | bfac8ee4affcee4c0010937f9dabb9fd5dd4e6ab /roundcubemail/program | |
| parent | f6c8cc551641ed095168c8fcaac32807d2a69a18 (diff) | |
- Fix rcube_mdb2::unixtimestamp for MS SQL (#1486015)
git-svn-id: https://svn.roundcube.net/trunk@2818 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/program')
| -rw-r--r-- | roundcubemail/program/include/rcube_mdb2.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/roundcubemail/program/include/rcube_mdb2.php b/roundcubemail/program/include/rcube_mdb2.php index 86d798a79..610aaf50a 100644 --- a/roundcubemail/program/include/rcube_mdb2.php +++ b/roundcubemail/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)"; |
