File: orafce--4.10--4.11.sql

package info (click to toggle)
orafce 4.16.3-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 2,856 kB
  • sloc: ansic: 12,914; sql: 8,984; lex: 1,054; makefile: 131; yacc: 82; python: 7; sh: 2
file content (11 lines) | stat: -rw-r--r-- 517 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
 
CREATE FUNCTION oracle.sys_extract_utc(timestamp with time zone)
RETURNS timestamp without time zone
AS 'MODULE_PATHNAME','orafce_sys_extract_utc'
LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
COMMENT ON FUNCTION oracle.sysdate() IS 'Extract timestamp at utc time zone';

CREATE FUNCTION oracle.sys_extract_utc(oracle.date)
RETURNS oracle.date
AS 'MODULE_PATHNAME','orafce_sys_extract_utc_oracle_date'
LANGUAGE C STABLE STRICT PARALLEL SAFE;
COMMENT ON FUNCTION oracle.sysdate() IS 'Extract timestamp at utc time zone';