Advanced Search

Oracle CURRENT_TIMESTAMP Function

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT CURRENT_TIMESTAMP,
  2. SYS_EXTRACT_UTC(CURRENT_TIMESTAMP)
  3. FROM dual;
  4.  
  5.  
  6. SELECT CURRENT_TIMESTAMP,
  7. CURRENT_TIMESTAMP - INTERVAL '4' HOUR
  8. FROM dual;
  9.  
  10. SELECT CURRENT_TIMESTAMP
  11. FROM dual;
  12.  
  13. SELECT CURRENT_TIMESTAMP(2)
  14. FROM dual;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.