Purpose
This function returns the date of the operating system on which the database server is running.
Notice
This function does not depend on the current session time zone, but on the time zone of the operating system on which the database server is running.
Syntax
SYSDATE
Return type
The DATE data type.
Examples
The following example outputs the current 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