summaryrefslogtreecommitdiffstats
path: root/lib/db.php
diff options
context:
space:
mode:
authorJörn Friedrich Dreyer <jfd@butonic.de>2013-06-25 09:52:04 +0200
committerJörn Friedrich Dreyer <jfd@butonic.de>2013-06-25 09:52:04 +0200
commit7273b43cd5b0047207763ca48abc46e5d0fcb130 (patch)
tree7e7ec68f03e3d6dd23c6bf8a6509e87a0c7f0286 /lib/db.php
parentbca2eb39fa1950a72e159dd6cc44598c387a927a (diff)
downloadnextcloud-server-7273b43cd5b0047207763ca48abc46e5d0fcb130.tar.gz
nextcloud-server-7273b43cd5b0047207763ca48abc46e5d0fcb130.zip
manuall calculate unix_timestamp 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 a6b81aaba69..f6acf6af1b7 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -754,6 +754,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))-TO_DATE(\'1970101000000\',\'YYYYMMDDHH24MiSS\'))*24*3600', $query );
}elseif( $type == 'mssql' ) {
$query = preg_replace( "/\`(.*?)`/", "[$1]", $query );
$query = str_replace( 'NOW()', 'CURRENT_TIMESTAMP', $query );