SELECT * FROM [dbo].[PLM_MID_EBOM] WHERE Convert(varchar,filemodfiydate,120) LIKE '2021-12%'

链接地址：[https://blog.csdn.net/siyubaobao1404/article/details/7452148]