CURRENT_TIMESTAMP function in Oracle

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

Syntax:

CURRENT_TIMESTAMP 

Example 1:

Select CURRENT_TIMESTAMP
from dual;

Output:
26-Jun-19 11.48.14.753745 PM -07:00
Explanation:
The result will be the current timestamp in the time zone of the current SQL session.

Please Share