SELECT TO_CHAR(SYSTIMESTAMP, 'TZR') AS server_tz_offset, TO_CHAR(SYSTIMESTAMP, 'mm/dd/YYYY HH24:MI:SSxFF') AS ts_date, TO_CHAR(SYSTIMESTAMP, 'mm/dd/YYYY HH24:MI:SSxFF TZH:TZM') AS ts_tz_date, FROM_TZ(CAST(TO_DATE(20010101093501,'yyyymmddhh24miss') AS TIMESTAMP), 'America/New_York') US_EST, FROM_TZ(CAST(SYSDATE AS TIMESTAMP), 'America/New_York') Date_Time, EXTRACT(SECOND FROM SYSTIMESTAMP) AS ts_sec, EXTRACT(MINUTE FROM SYSTIMESTAMP) AS ts_min, EXTRACT(HOUR FROM SYSTIMESTAMP) AS ts_hour, EXTRACT(DAY FROM SYSTIMESTAMP) AS ts_day, EXTRACT(MONTH FROM SYSTIMESTAMP) AS ts_month, EXTRACT(YEAR FROM SYSTIMESTAMP) AS ts_year, EXTRACT(TIMEZONE_HOUR FROM SYSTIMESTAMP) AS time_zone_hr, EXTRACT(TIMEZONE_MINUTE FROM SYSTIMESTAMP) AS time_zone_min, EXTRACT(TIMEZONE_ABBR FROM SYSTIMESTAMP) AS time_zone_abbr, --to be set EXTRACT(TIMEZONE_REGION FROM SYSTIMESTAMP) AS time_zone_region --to be set FROM DUAL;
23425