Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. Datetime Functions
  5. CURRENT_DATE

CURRENT_DATE

  • 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
Was this article helpful to you? Yes No

How can we help?