Advanced Search

Oracle LOCALTIMESTAMP Function

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

Expand | Embed | Plain Text

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

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.