summaryrefslogtreecommitdiffstats
path: root/lib/db.php
diff options
context:
space:
mode:
authorBart Visscher <bartv@thisnet.nl>2013-06-12 18:48:18 +0200
committerBart Visscher <bartv@thisnet.nl>2013-06-24 22:38:19 +0200
commit6300b95896540dcac145598edf50ec778be1a3eb (patch)
tree787c8e2aaa606459724be24182aac7f327c07782 /lib/db.php
parentdca8c1cbc138203d4069660bb8c1caf23ff68e04 (diff)
downloadnextcloud-server-6300b95896540dcac145598edf50ec778be1a3eb.tar.gz
nextcloud-server-6300b95896540dcac145598edf50ec778be1a3eb.zip
UNIX_TIMESTAMP replace for Oracle
Diffstat (limited to 'lib/db.php')
-rw-r--r--lib/db.php1
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/db.php b/lib/db.php
index 41ec5ec67eb..ab4364299c4 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -517,6 +517,7 @@ class OC_DB {
} elseif( $type == 'oci' ) {
$query = str_replace( '`', '"', $query );
$query = str_ireplace( 'NOW()', 'CURRENT_TIMESTAMP', $query );
+ $query = str_ireplace( 'UNIX_TIMESTAMP()', "(cast(sys_extract_utc(systimestamp) as date) - date'1970-01-01') * 86400", $query );
}elseif( $type == 'mssql' ) {
$query = preg_replace( "/\`(.*?)`/", "[$1]", $query );
$query = str_replace( 'NOW()', 'CURRENT_TIMESTAMP', $query );