将date转换成字符类型

where CONVERT(varchar,createTime,21) like ‘%2021-01-12%’

如果是date

where createTimebetween ‘2019-05-01’ and ‘2019-05-31’

如果是 datetime

where createTime between ‘2019-05-01 00:00:00.000’ and ‘2019-05-31 23:59:59.999’

select * from [t_Company_TakeOrderSet] where createTime between ‘2019-05-01’ and ‘2021-05-31’

如果是 varchar

建议修改为 date 或 datetime ，毕竟数据可能是不规范的。