René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -

new_time [Oracle SQL]

new_time(date,a_timezone, another_timezone)
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.