Oracle Current Date Query: SYSDATE

You can use the following statement in Oracle to query the current system date:

SELECT SYSDATE FROM DUAL;

This statement will return a result set containing the current date and time. If only the date part is needed, the following statement can be used:

SELECT TRUNC(SYSDATE) FROM DUAL;

This statement will return the date portion of the current date, while the time portion will be truncated.