aboutsummaryrefslogtreecommitdiff
path: root/res/sql/functions/pg_current_datetime.sql
diff options
context:
space:
mode:
Diffstat (limited to 'res/sql/functions/pg_current_datetime.sql')
-rw-r--r--res/sql/functions/pg_current_datetime.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/res/sql/functions/pg_current_datetime.sql b/res/sql/functions/pg_current_datetime.sql
new file mode 100644
index 0000000..75b1b96
--- /dev/null
+++ b/res/sql/functions/pg_current_datetime.sql
@@ -0,0 +1,10 @@
1CREATE OR REPLACE FUNCTION current_datetime()
2 RETURNS TIMESTAMP WITH TIME ZONE
3AS '
4BEGIN
5
6--RETURN to_timestamp(''2014-01-01'', ''YYYY-MM-DD'');
7 RETURN now();
8
9END;
10' LANGUAGE plpgsql;