1 files changed, 10 insertions, 0 deletions

diff --git a/res/sql/functions/orcl_current_datetime.sql b/res/sql/functions/orcl_current_datetime.sql
new file mode 100644
index 0000000..bf454d8
--- /dev/null
+++ b/res/sql/functions/orcl_current_datetime.sql
@@ -0,0 +1,10 @@
+CREATE OR REPLACE FUNCTION current_datetime
+  RETURN TIMESTAMP WITH TIME ZONE
+AS
+  BEGIN
+
+--RETURN TO_TIMESTAMP_TZ('2014-01-01', 'YYYY-MM-DD');
+    RETURN CURRENT_TIMESTAMP;
+
+  END;
+/