Changeset 6666 for trunk/include/dblayer/functions_pgsql.inc.php

Timestamp:

Jul 6, 2010, 2:14:17 PM (14 years ago)

Author:

nikrou

Message:

Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()
Add a new function pwg_db_date_to_ts() to calculate a timestamp from a date

File:

• trunk/include/dblayer/functions_pgsql.inc.php (modified) (1 diff)

trunk/include/dblayer/functions_pgsql.inc.php

@@ -597 +597 @@
 }
 
+function pwg_db_date_to_ts($date) 
+{
+  return 'EXTRACT(EPOCH FROM '.$date.')';
+}
+
 // my_error returns (or send to standard output) the message concerning the
 // error occured for the last pgsql query.