Oracle FROM_TZ Function


/ Published in: SQL
Save to your folder(s)

A few examples of the FROM_TZ function.


Copy this code and paste it in your HTML
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.