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.
Select SYSTIMESTAMP INTO var from dual;
The var is a variable that will contain the system’s timestamp at the moment of execution.