SELECT TO_TIMESTAMP_TZ('8-DEC-15 10:04:01 AM +2:00') AS TS_TEST FROM dual;

SELECT TO_TIMESTAMP_TZ('8-DEC-2015 02:44 AM +6:00', 'DD-MON-YYYY HH:MI AM TZH:TZM') AS TS_TEST FROM dual;

SELECT TO_TIMESTAMP_TZ('12-DEC-2015 6:51 PM -11:00', 'DD-MON-YYYY HH:MI AM TZH:TZM') AS TS_TEST FROM dual;

http://www.databasestar.com/oracle-to_timestamp_tz/

A few examples of the TO_TIMESTAMP_TZ function.

Oracle TO_TIMESTAMP_TZ Function

sql, Oracle

SQL