Advanced Search

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