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.