Oracle SYSDATE: Get System Date & Time

You can use the SYSDATE function in Oracle database to fetch the current system date and time. You can use the following query to retrieve the system date:

SELECT SYSDATE FROM DUAL;

This will return a result set containing the current system date and time. You can also use the TO_CHAR function to format the system date into a specific date format. For example, the following query will return the current system date in the format YYYY-MM-DD:

SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD') FROM DUAL;