Posted By

bbrumm on 01/28/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 01/28/17 06:38am

Statistics

Viewed 822 times

Favorited by 0 user(s)

Related snippets

Oracle TO_TIMESTAMP_TZ Function

/ Published in: SQL

A few examples of the TO_TIMESTAMP_TZ function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;