Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle CURRENT_TIMESTAMP Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 66 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?