Advanced Search

Return to Snippet

Revision: 71255
at January 28, 2017 06:38 by bbrumm
Initial Code 
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;
Initial URL 
http://www.databasestar.com/oracle-to_timestamp_tz/
Initial Description 
A few examples of the TO_TIMESTAMP_TZ function.
Initial Title 
Oracle TO_TIMESTAMP_TZ Function
Initial Tags 
sql, Oracle
Initial Language 
SQL