Purpose
SYSDATE returns the current date and time of the operating system on which the current OBServer node resides.
Notice
This function gets the date and time in the time zone of the operating system on which the OBServer node 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