aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2020-01-18 20:00:37 +0000
committerMario <mario@mariovavti.com>2020-01-18 20:00:37 +0000
commitcbaf4b7536c0b056bc8079aa39b24f2e2c312dd6 (patch)
treeb10938381e680a0b6df23415275c1838465af60c
parent570d84c031d9cdf0e16aa79bc4a7a111345cc3f3 (diff)
downloadvolse-hubzilla-cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6.tar.gz
volse-hubzilla-cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6.tar.bz2
volse-hubzilla-cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6.zip
introduce db_str_to_date()
-rwxr-xr-xinclude/dba/dba_driver.php4
-rwxr-xr-xinclude/dba/dba_pdo.php9
2 files changed, 13 insertions, 0 deletions
diff --git a/include/dba/dba_driver.php b/include/dba/dba_driver.php
index cfb208e2d..b96601fec 100755
--- a/include/dba/dba_driver.php
+++ b/include/dba/dba_driver.php
@@ -307,6 +307,10 @@ function db_use_index($str) {
return \DBA::$dba->use_index($str);
}
+function db_str_to_date($str) {
+ return \DBA::$dba->str_to_date($str);
+}
+
/**
* @brief Execute a SQL query with printf style args.
*
diff --git a/include/dba/dba_pdo.php b/include/dba/dba_pdo.php
index 0279342ec..0ae69fe27 100755
--- a/include/dba/dba_pdo.php
+++ b/include/dba/dba_pdo.php
@@ -139,6 +139,15 @@ class dba_pdo extends dba_driver {
}
}
+ function str_to_date($str) {
+ if($this->driver_dbtype === 'pgsql') {
+ return "TO_TIMESTAMP($str, 'YYYY-MM-DD HH:MI:SS')";
+ }
+ else {
+ return "STR_TO_DATE($str, '%Y-%m-%d %H:%i:%s')";
+ }
+ }
+
function quote_interval($txt) {
if($this->driver_dbtype === 'pgsql') {
return "'$txt'";