TO_TIMESTAMP_TZ

TO_TIMESTAMP_LTZ(EXPR)

Equivalent to TO_TIMESTAMP except that it uses the local time zone, or keeps the original timezone if the input is a timezone-aware timestamp.