diff options
Diffstat (limited to 'include/dblayer/functions_sqlite.inc.php')
-rw-r--r-- | include/dblayer/functions_sqlite.inc.php | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/include/dblayer/functions_sqlite.inc.php b/include/dblayer/functions_sqlite.inc.php index 72f539c92..7a33b09a2 100644 --- a/include/dblayer/functions_sqlite.inc.php +++ b/include/dblayer/functions_sqlite.inc.php @@ -55,7 +55,6 @@ function pwg_db_connect($host, $user, $password, $database) } $link->createFunction('now', 'pwg_now', 0); - $link->createFunction('hour', 'pwg_hour', 1); $link->createFunction('unix_timestamp', 'pwg_unix_timestamp', 0); $link->createFunction('md5', 'md5', 1); $link->createFunction('if', 'pwg_if', 3); @@ -514,6 +513,11 @@ function pwg_db_get_recent_period($period, $date='CURRENT_DATE') return $d; } +function pwg_db_get_hour($date) +{ + return 'strftime(\'%H\', '.$date.')'; +} + function pwg_db_get_date_YYYYMM($date) { return 'strftime(\'%Y%m\','.$date.')'; @@ -583,11 +587,6 @@ function pwg_now() return date('Y-m-d H:i:s'); } -function pwg_hour($datetime) -{ - return strftime('%H', $datetime); -} - function pwg_unix_timestamp() { return time(); |