CURRENT_TIMESTAMP – Oracle SQL Function

CURRENT_TIMESTAMP returns the cyrrent system timestamp.

You can also specify an optional precision argument to control the precision of the seconds in the time.

Example:

SELECT CURRENT_TIMESTAMP AS RESULT FROM DUAL;

RESULT
————————–
05-SEP-05 01.24.11.968000 PM -4:00