CURRENT_DATE

The Oracle & PLSQL CURRENT_DATE function returns the current date in the time zone of the current SQL session.

CURRENT_DATE

Example 1:

SELECT CURRENT_DATE FROM DUAL;

returns:

31/10/2015 12:29:47