Return to Snippet

Revision: 71551
at March 1, 2017 05:43 by bbrumm


Initial Code
--Example 1
SELECT 
FROM_TZ(TIMESTAMP '2016-07-13 19:20:14', '02:00') AS tz_test
FROM dual;

--Example 2
SELECT 
FROM_TZ(TIMESTAMP '2016-07-13 04:06:55', '-11:00') AS tz_test
FROM dual;

Initial URL
http://www.databasestar.com/oracle-from_tz/

Initial Description
A few examples of the FROM_TZ function.

Initial Title
Oracle FROM_TZ Function

Initial Tags
sql, Oracle

Initial Language
SQL