MySQL如何查询当天产生的全部数据？？？

Question

数据表中存放的是系统出/入账记录,要做统计,每天出一份账单表显示当天的收支记录,这种查询的SQL语句该怎么写呢???

阿神 · Answer

Crab, it’s been solved:

SELECT *
FROM table_name
WHERE TO_DAYS(createDate) = TO_DAYS(NOW());