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!

How to get Time Zones for Different Countries

User_5JLSWJan 26 2022

SELECT * from V$TIMEZONE_NAMES -- This gives the time zone Information
-- I have tried with this SQL, This is not working, Appreciate if you can help

Example : I want for US and Germany current sysdate time
select
TO_CHAR(FROM_TZ(SYSDATE,DBTIMEZONE) AT TIME ZONE 'America/Phoenix','DD-MON-YYYY HH12:MI:SS AM','NLS_DATE_LANGUAGE=AMERICAN') SYSTEM_DATE_PHX
from dual
This post has been answered by Frank Kulash on Jan 26 2022
Jump to Answer
Comments
Post Details
Added on Jan 26 2022
10 comments
2,484 views
2 mentions