|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
new_time [Oracle SQL]
new_time converts date from a_timezone into another_timezone.
Although Oracle knows about more than a thousand timezones (v$timezone_names), only the following time zones are allowed: AST, ADT, BST, BDT, CST, CDT, EST, EDT, GMT, HST, HDT, MST, MDT, NST, PST, PDT, YST and YDT.
See also from_tz.