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.