mysql(4) : 筛选当天数据

select * from table where date(regdate) = curdate();

 

参考及详细 : https://www.cnblogs.com/softidea/p/6387649.html

 

扩展: 筛选当月数据

select name,submittime from enterprise where date_format(submittime,'%Y-%m')=date_format(now(),'%Y-%m')

 

 

END。