时间查询

SELECT * FROM `subject` WHERE `postdate` >= '2015-03-06 ' AND `postdate` < '2015-03-07'

mysql 默认的查询时间为：

SELECT * FROM `subject` WHERE `postdate` >= '2015-03-06 00:00:00 ' AND `postdate` < '2015-03-07 00:00:00'

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/sunzhenyong/p/4318665.html