本月:
SELECT * FROM your_table WHERE MONTH(your_date_column) = MONTH(CURDATE()) AND YEAR(your_date_column) = YEAR(CURDATE());
本季度:
SELECT * FROM your_table WHERE QUARTER(your_date_column) = QUARTER(CURDATE()) AND YEAR(your_date_column) = YEAR(CURDATE());
本年:
SELECT * FROM your_table WHERE YEAR(your_date_column) = YEAR(CURDATE());