[geeklog-cvs] geeklog: added from_unixtime function

[geeklog-cvs at lists.geeklog.net]

changeset 7653:8710ccd89021
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/8710ccd89021
user: stan <yankees26an at gmail.com>
date: Mon Aug 31 14:11:24 2009 -0400
description:
added from_unixtime function

diffstat:

 sql/pgsql_tableanddata.php |  5 +++++
 1 files changed, 5 insertions(+), 0 deletions(-)

diffs (15 lines):

diff -r fa8bbf005939 -r 8710ccd89021 sql/pgsql_tableanddata.php
--- a/sql/pgsql_tableanddata.php	Sat Aug 29 12:45:24 2009 -0400
+++ b/sql/pgsql_tableanddata.php	Mon Aug 31 14:11:24 2009 -0400
@@ -534,6 +534,11 @@
 ' LANGUAGE 'SQL';
 ";
 
+$_SQL[] = "CREATE OR REPLACE FUNCTION FROM_UNIXTIME(integer) RETURNS timestamp AS '
+SELECT $1::ABSTIME::TIMESTAMP AS result;
+' LANGUAGE 'SQL';
+";
+
 $_SQL[] = "CREATE OR REPLACE FUNCTION CURDATE() RETURNS date AS 'SELECT current_date AS result' LANGUAGE 'SQL';";
 
 $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (1,3) ";