Changeset 6464 for branches/2.1/include/dblayer/functions_sqlite.inc.php

Timestamp:

Jun 4, 2010, 9:39:02 PM (14 years ago)

Author:

nikrou

Message:

Bug 1717 fixed : SQLite: access failure on Admin > Tools > History
hour function doesn't exists
Merge from trunk.

File:

• branches/2.1/include/dblayer/functions_sqlite.inc.php (modified) (2 diffs)

branches/2.1/include/dblayer/functions_sqlite.inc.php

@@ -56 +56 @@
 
   $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);
@@ -583 +584 @@
 }
 
+function pwg_hour($datetime)
+{
+  return strftime('%H', $datetime);
+}
+
 function pwg_unix_timestamp()
 {