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

from_tz [Oracle SQL]

from_tz(timestamp_value, 'timezone')
Find available timezones in v$timezone_names.
See also new_time.