有没有办法在SQL中选择当前月份的列？

SELECT *
FROM your_table
WHERE MONTH(your_date_column) = MONTH(CURDATE())
AND YEAR(your_date_column) = YEAR(CURDATE());

SELECT *
FROM your_table
WHERE EXTRACT(MONTH FROM your_date_column) = EXTRACT(MONTH FROM CURRENT_DATE)
AND EXTRACT(YEAR FROM your_date_column) = EXTRACT(YEAR FROM CURRENT_DATE);

SELECT *
FROM your_table
WHERE MONTH(your_date_column) = MONTH(GETDATE())
AND YEAR(your_date_column) = YEAR(GETDATE());

SELECT *
FROM your_table
WHERE TO_CHAR(your_date_column, 'MM') = TO_CHAR(SYSDATE, 'MM')
AND TO_CHAR(your_date_column, 'YYYY') = TO_CHAR(SYSDATE, 'YYYY');