CURRENT_DATE in Oracle

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.

Please follow and like us:
Content Protection by DMCA.com