SYSDATE

Oracle

SYSDATE()

Example

SELECT SYSDATE FROM dual;

Output

SYSDATE
-------------------------
27-JUL-21

Explanation

The SYSDATE function is used in Oracle to get the current system date and time from the operating system on which the database resides. In the provided example, SELECT SYSDATE FROM dual;, SYSDATE returns the current date and time set on your database server. ‘dual’ is a special one-row, one-column table present by default in Oracle and other database installations.