Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract timezone name from systimestamp

Parameshwaran DuraisamyJan 30 2017 — edited Jan 30 2017

Hi,

I tried to extract the timezone abbreviation by using the following command:

SELECT EXTRACT(TIMEZONE_ABBR FROM systimestamp) FROM DUAL;

But it is returning UNK as the result.

Kindly correct me the way to find the timezone abbreviation.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2017
Added on Jan 30 2017
4 comments
2,720 views