Advanced Search

Oracle FROM_TZ Function

/ Published in: SQL
Save to your folder(s)
A few examples of the FROM_TZ function.

Expand | Embed | Plain Text

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.