Posted By

bbrumm on 03/03/17


Tagged

sql Oracle


Versions (?)

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  

You need to login to post a comment.