如何在oracle中以不同的格式显示日期

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

SELECT TO_DATE('2022-01-01', 'YYYY-MM-DD') AS date_value FROM DUAL;

SELECT TRUNC(SYSDATE, 'YYYY') AS truncated_date FROM DUAL;

SELECT ROUND(SYSDATE, 'MM') AS rounded_date FROM DUAL;

SELECT EXTRACT(YEAR FROM SYSDATE) AS year FROM DUAL;

SELECT NEXT_DAY(SYSDATE, 'TUESDAY') AS next_tuesday FROM DUAL;

SELECT LAST_DAY(SYSDATE) AS last_day_of_month FROM DUAL;