sql查询当天时间
like关键字
将date转换成字符类型
where CONVERT(varchar,createTime,21) like ‘%2021-01-12%’
between 和 and
如果是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 ,毕竟数据可能是不规范的。