select * from es_order_item where es_order_item.product IS NULL and DAY(create_date)!=23
convert(char(10),create_date,120)= '2014_04_23' create_date not like '%2014_04_23%'
es_order_item.product IS NULL select * from info where DateDiff(dd,datetime,getdate())=0
select * from 表 where day(日期类型字段)=天
select * from es_goods where es_goods.type=3
BETWEEN '2017-03-26 00:00:00' AND '2017-03-27 23:59:59'