program/include/rcube_mdb2.inc
@@ -411,6 +411,25 @@ /** * Return SQL function for current time and date * * @return string SQL function to use in query * @access public */ function now() { switch($this->db_provider) { case 'mssql': return "getdate()"; default: return "now()"; } } /** * Return SQL statement to convert a field value into a unix timestamp * * @param string Field name @@ -425,6 +444,9 @@ return "EXTRACT (EPOCH FROM $field)"; break; case 'mssql': return "datediff(s, '1970-01-01 00:00:00', $field)"; default: return "UNIX_TIMESTAMP($field)"; }