SYSTIMESTAMP function in Oracle

SYSTIMESTAMP is one of the vital Date/Time functions of Oracle. It is used to get the current system timestamp on the local database. The SYSTIMESTAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax:

SYSTIMESTAMP 

Example:

Select SYSTIMESTAMP
INTO var
from dual;

Explanation: The var is a variable that will contain the system’s timestamp at the moment of execution.

Please follow and like us: