CURRENT_DATE in Oracle

by

CURRENT_DATE is one of the vital Date/Time functions of Oracle. It is used to get the current date in the time zone of the current SQL session. The CURRENT_DATE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax: 

CURRENT_DATE

Example 1: 

Select CURRENT_DATE
from dual;

Output: 

7/26/2019 11:48:14 AM

Explanation:
The result will be the current date in the time zone of the current SQL session.