diff options
| author | Mario <mario@mariovavti.com> | 2020-01-18 20:00:37 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2020-01-18 20:00:37 +0000 |
| commit | cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6 (patch) | |
| tree | b10938381e680a0b6df23415275c1838465af60c /include/dba/dba_pdo.php | |
| parent | 570d84c031d9cdf0e16aa79bc4a7a111345cc3f3 (diff) | |
| download | volse-hubzilla-cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6.tar.gz volse-hubzilla-cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6.tar.bz2 volse-hubzilla-cbaf4b7536c0b056bc8079aa39b24f2e2c312dd6.zip | |
introduce db_str_to_date()
Diffstat (limited to 'include/dba/dba_pdo.php')
| -rwxr-xr-x | include/dba/dba_pdo.php | 9 |
1 files changed, 9 insertions, 0 deletions
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'"; |