Assue your datetime field name is t_date.The correct statement is below.select * from yourtablename where t_date between current_date() and date_format(current_date,'%Y-%m-%d 23:59:59');
select * from tablename where DATEDIFF("d", columnname, getdate())<1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货