sql datetime类型数据如果进行模糊查询

select * from Table1 where CONVERT(nvarchar(50),CreateTime,120) like '%2019'

原文地址:https://www.cnblogs.com/xiaonangua/p/10984616.html