EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR'))


SQL>
SQL> select EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ(
  2      '01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR'))
  3      AS TZA from dual;

TZA
----------
PST

SQL>

Related examples in the same category

1.	The EXTRACT() function returns the value of a specified datetime field from a datetime or interval value expression.
2.	EXTRACT(): return a year, month, day, hour, minute, second, or time zone from x
3.	EXTRACT(MONTH FROM TO_DATE('01-JAN-2005 19:15:26', 'DD-MON-YYYY HH24:MI:SS'))
4.	EXTRACT(DAY FROM TO_DATE('01-JAN-2005 19:15:26', 'DD-MON-YYYY HH24:MI:SS'))
5.	EXTRACT(): get the hour, minute, and second from a TIMESTAMP returned by TO_TIMESTAMP()
6.	EXTRACT(TIMEZONE_HOUR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM')
7.	EXTRACT(TIMEZONE_MINUTE FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM'))
8.	EXTRACT(TIMEZONE_REGION FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR'))
9.	select extract( year from add_months(sysdate,36) ) "3 Years Out"

EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ('01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR')) : EXTRACT « Date Timezone « Oracle PL / SQL

Related examples in the same category