不同的时间函数
SELECT
TO_DAYS( '2021-06-21' ) AS '获取天数',
TO_DAYS( '2021-06-20' ) AS '获取天数1',
HOUR (
NOW()) AS '获取当前时间的小时数',
NOW() AS '获取当前时间',
curdate() AS '获取当前时间',
curtime() AS '获取当前时间'
筛选距离今天少于一天的数据
select createTime
from user
where TO_DAYS(NOW()) - TO_DAYS(createTime) <= 1
group by createTime