res/sql/functions/orcl_current_datetime.sql


1
2
3
4
5
6
7
8
9
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;
/