SYSDATE is one of the vital Date/Time functions of Oracle. It is used to get the current system date and time on the local database. The result generated is either as a time zone offset or a time zone region name. The SYSDATE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
SYSDATE
Example:
Select SYSDATE
INTO var
from dual; |
Explanation:
The var is a variable that will contain the system’s date and time at the moment of execution.