(info_AddTime BETWEEN
'2004/07/26' AND '2004/07/28')
换成:
datediff(day,'2004-07-26',
info_AddTime)>=0 and datediff(day,info_AddTime,'2004-07-28')>=0
或者可以是:
(info_AddTime BETWEEN
'2004-07-26 00:00:00' AND '2004-07-28 23:59:00')
'2004/07/26' AND '2004/07/28')
换成:
datediff(day,'2004-07-26',
info_AddTime)>=0 and datediff(day,info_AddTime,'2004-07-28')>=0
或者可以是:
(info_AddTime BETWEEN
'2004-07-26 00:00:00' AND '2004-07-28 23:59:00')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货