Posted By

bbrumm on 03/03/17

Tagged

sql Oracle

Viewed 1 times

Oracle LOCALTIMESTAMP Function


/ Published in: SQL

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

A few examples of the LOCALTIMESTAMP function.

  1. --LOCALTIMESTAMP
  2.  
  3. --Example 1
  4. SELECT LOCALTIMESTAMP
  5. FROM dual;
  6.  
  7. --Example 2
  8. ALTER SESSION SET TIME_ZONE = '+4:0';
  9.  
  10. SELECT LOCALTIMESTAMP
  11. FROM dual;
  12.  
  13.  
  14. --Example 3
  15. SELECT LOCALTIMESTAMP(3)
  16. FROM dual;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.