Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF9 TZR';
CREATE TABLE table_name ( column_name ) AS
SELECT 1368046452000 FROM DUAL;
1 rows affected

SELECT ( TIMESTAMP '1970-01-01 00:00:00 UTC' + column_name * INTERVAL '0.001' SECOND )
FROM   table_name


(TIMESTAMP'1970-01-0100:00:00UTC'+COLUMN_NAME*INTERVAL'0.001'SECOND)


2013-05-08 20:54:12.000000000 UTC


SELECT ( TIMESTAMP '1970-01-01 00:00:00 UTC' + column_name * INTERVAL '0.001' SECOND )
         AS UTC_TIMESTAMP,
       CAST(
         ( TIMESTAMP '1970-01-01 00:00:00 UTC' + column_name * INTERVAL '0.001' SECOND )
           AS DATE
       ) AS UTC_DATE,
       CAST(
         ( TIMESTAMP '1970-01-01 00:00:00 UTC' + column_name * INTERVAL '0.001' SECOND )
           AT TIME ZONE 'PST'
           AS DATE
       ) AS PST_DATE
FROM   table_name;


UTC_TIMESTAMP
UTC_DATE
PST_DATE


2013-05-08 20:54:12.000000000 UTC
2013-05-08 20:54:12
2013-05-08 13:54:12