• CURRENT_DATE returns the current date in the session time zone

Syntax: CURRENT_DATE

• This function requires no arguments.
• The data type of the returned value is DATE.
• The format returned depends on the value of the NLS_DATE_FORMAT initialization parameter.

SELECT CURRENT_DATE curr_time FROM DUAL;

CURR_TIME
---------
12-NOV-20

• By default CURRENT_DATE does not display the time. You must use TO_CHAR conversion function to display the time along with date as per specified format.

SELECT TO_CHAR(CURRENT_DATE, 'MM-DD-YYYY HH24:MI:SS') curr_time 
  FROM DUAL;

CURR_TIME
-------------------
11-12-2020 21:23:34