From 3b83c7fa74eb90e02317528dd672fa2afe457b77 Mon Sep 17 00:00:00 2001 From: Jörn Friedrich Dreyer Date: Mon, 27 Aug 2012 18:37:16 +0200 Subject: update now(), current_timestamp and backtick replacement --- lib/db.php | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'lib/db.php') diff --git a/lib/db.php b/lib/db.php index 5ef67202a10..4214451c85f 100644 --- a/lib/db.php +++ b/lib/db.php @@ -534,10 +534,9 @@ class OC_DB { $query = str_replace( '`', '"', $query ); $query = str_replace( 'NOW()', 'datetime(\'now\')', $query ); $query = str_replace( 'now()', 'datetime(\'now\')', $query ); - }elseif( $type == 'mysql' ){ - $query = str_replace( 'NOW()', 'CURRENT_TIMESTAMP', $query ); - $query = str_replace( 'now()', 'CURRENT_TIMESTAMP', $query ); - }elseif( $type == 'pgsql' || $type == 'oci' ){ + }elseif( $type == 'pgsql' ){ + $query = str_replace( '`', '"', $query ); + }elseif( $type == 'oci' ){ $query = str_replace( '`', '"', $query ); $query = str_replace( 'NOW()', 'CURRENT_TIMESTAMP', $query ); $query = str_replace( 'now()', 'CURRENT_TIMESTAMP', $query ); -- cgit v1.2.3