SELECT * FROM table
WHERE DATE(timestamp) = '2012-05-05'
但是,如果您在timestamp列上有索引,则这样做会更快,因为它可以利用索引:
SELECT * FROM table
WHERE timestamp BETWEEN '2012-05-05 00:00:00' AND '2012-05-05 23:59:59'
如何比较时间戳日期与MySQL中的仅日期参数?
SELECT * FROM table
WHERE DATE(timestamp) = '2012-05-05'
但是,如果您在timestamp列上有索引,则这样做会更快,因为它可以利用索引:
SELECT * FROM table
WHERE timestamp BETWEEN '2012-05-05 00:00:00' AND '2012-05-05 23:59:59'