How does Oracle retrieve the current date in year, mont…

Oracle can use the SYSDATE function to obtain the current date and time.

The following statement can be used to extract the year, month, and date from the SYSDATE function:

SELECT TO_CHAR(SYSDATE, 'YYYY') AS year,
       TO_CHAR(SYSDATE, 'MM') AS month,
       TO_CHAR(SYSDATE, 'DD') AS day
FROM dual;

This will return the current year, month, and date as the result.