CURRENT_TIMESTAMP

The Oracle and PL/SQL CURRENT_TIMESTAMP function returns the current date and time.

CURRENT_TIMESTAMP

Example 1:

SELECT CURRENT_TIMESTAMP FROM DUAL;

returns:

31/10/2007 12:41:53,787000 +06:00