SQL中CONVERT()函数用法详解

https://www.cnblogs.com/alibai/p/3553657.html

 

以年月为条件查询，select * from table where year(q_date)='2024'  and month(kq_date)='02'