The SYSDATE function returns the current date and time. Notice
This function is not dependent on the time zone of the current session but on the time zone of the Linux operating system that runs on the database host.
Syntax
SYSDATE
Parameters
None
Return type
DATE data type
Examples
In the following example, the current time is returned in the specified format:
SELECT TO_CHAR
(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
FROM DUAL;
The following query result is returned:
+---------------------+
| NOW |
+---------------------+
| 03-08-2020 20:44:04 |
+---------------------+