This will give the desired timezone’s date and
time.
Syntax: new_time (date, current_timezone, desired_timezone)
Available
timezones are as follows.
TIMEZONES
AST/ADT -- Atlantic
standard/day light time
BST/BDT -- Bering
standard/day light time
CST/CDT -- Central
standard/day light time
EST/EDT -- Eastern
standard/day light time
GMT -- Greenwich mean time
HST/HDT -- Alaska-Hawaii
standard/day light time
MST/MDT -- Mountain
standard/day light time
NST
-- Newfoundland standard time
PST/PDT -- Pacific
standard/day light time
YST/YDT -- Yukon standard/day light
time
Ex:
SQL> select to_char(new_time(sysdate,'gmt','yst'),'dd mon yyyy
hh:mi:ss am') from
dual;
TO_CHAR(NEW_TIME(SYSDAT
-----------------------------------
24 dec 2006
02:51:20 pm
SQL> select to_char(new_time(sysdate,'gmt','est'),'dd mon yyyy
hh:mi:ss am') from
dual;
TO_CHAR(NEW_TIME(SYSDAT
-----------------------
24 dec 2006
06:51:26 pm
