SYSTIMESTAMP function in Oracle

by

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.