Quick Search:
 
 The Oracle CURRENT_TIMESTAMP Function      [Return To Index] Jump to:  

Term: CURRENT_TIMESTAMP

Definition:
The Oracle CURRENT_TIMESTAMP function will give you the current time with all details. It returns the current timestamp with time zone for the current session's time zone. This is similar to the Oracle SYSTIMESTAMP function, but the precision to which the TIMESTAMP is returned can be specified. (If no precision is specified, the default is 6.)

Example Syntax:

SELECT CURRENT_TIMESTAMP FROM DUAL;


You may also want to see the entries for SYSTIMESTAMP and LOCALTIMESTAMP, plus the Timestamp Data Type Demos.

Related Links:

Related Code Snippets:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org