Advanced Search

Oracle SYSTIMESTAMP Function

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. --SYSTIMESTAMP
  2.  
  3. --Example 1
  4. SELECT SYSTIMESTAMP
  5. FROM dual;
  6.  
  7. --Example 2
  8. SELECT SYSDATE, SYSTIMESTAMP
  9. FROM dual;
  10.  
  11. --Example 3
  12. SELECT SYSTIMESTAMP, TO_CHAR(SYSTIMESTAMP, 'dd Mon yyyy') AS text_output
  13. FROM dual;

URL: http://www.databasestar.com/oracle-systimestamp-function/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.