Transforming DATE values across multiple time zones using the NEW_TIME function

The NEW_TIME function transforms the DATE value using input_timezone (time zone of the source) and output_timezone (time zone of the destination). It returns the DATE value, regardless of the implicit conversion of the input. All parameters need to be specified. If the original DATE value provided is NULL, then the output is NULL as well:

NEW_TIME(<p_date>, <input_time_zone>, <output_timezone>)

The limitation of the NEW_TIME method is associated with the list of available time zones that can be referenced. The following table shows a list of available values:

Time zone value reference	Meaning
AST, ADT	Atlantic Standard or Daylight Time
BST, BDT	Bering Standard or Daylight Time
...