在Oracle SQL中从计算的日期字段中提取日期

SELECT TO_CHAR(date_column, 'YYYY-MM-DD') AS extracted_date
FROM your_table;

SELECT TRUNC(date_column) AS extracted_date
FROM your_table;

SELECT EXTRACT(YEAR FROM date_column) AS extracted_year,
       EXTRACT(MONTH FROM date_column) AS extracted_month,
       EXTRACT(DAY FROM date_column) AS extracted_day
FROM your_table;