Purpose
You can call this function to return the current date and time of the operating system on which the current database server resides.
Notice
This function gets the date and time in the time zone of the operating system on which the database server resides, regardless of the time zone of the current session.
Syntax
SYSDATE
Return type
The return type is DATE.
Examples
The following example returns the current date and time in the specified format.
obclient> SELECT SYSDATE,TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" FROM DUAL;
+-----------+---------------------+
SYSDATE NOW
+-----------+---------------------+
18-NOV-21 11-18-2021 10:23:00
+-----------+---------------------+
1 row in set