Spacewalk DB Schema - Function - EPOCH_SECONDS_TO_TIMESTAMP_TZ returns TIMESTAMP WITH LOCAL TIME ZONE

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips

Arguments Source

EPOCH_SECONDS_TO_TIMESTAMP_TZ

DDL script

Arguments:

Name	Data Type	Default Value	In/Out
SECS	NUMBER(38)		IN

Returns:

TIMESTAMP WITH LOCAL TIME ZONE

Source

Legend: comment string keyword reserved word operator

     1: function epoch_seconds_to_timestamp_tz(secs in number)
     2: return timestamp with local time zone
     3: is
     4: begin
     5: 	return to_timestamp_tz('1970-01-01 00:00:00 UTC', 'YYYY-MM-DD HH24:MI:SS TZR') + numtodsinterval(secs, 'second');
     6: end;