SYSDATE

SYSDATE is a SQL function that returns the current date and time set on the system. The function does not require any parameters.

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.