Posted By

bbrumm on 03/01/17


Tagged

sql Oracle


Versions (?)

Oracle FROM_TZ Function


 / Published in: SQL
 

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

A few examples of the FROM_TZ function.

  1. --Example 1
  2. SELECT
  3. FROM_TZ(TIMESTAMP '2016-07-13 19:20:14', '02:00') AS tz_test
  4. FROM dual;
  5.  
  6. --Example 2
  7. SELECT
  8. FROM_TZ(TIMESTAMP '2016-07-13 04:06:55', '-11:00') AS tz_test
  9. FROM dual;

Report this snippet  

You need to login to post a comment.