查询最接近某个 小时的数据
SELECT * FROM 表名 WHERE hour(时间字段) BETWEEN 8 and 12
and 时间字段 BETWEEN '2022-10-01' and NOW()
GROUP BY 时间字段asc
LIMIT 1
查询最接近某个时间的数据
SELECT *, abs(UNIX_TIMESTAMP(时间字段)-UNIX_TIMESTAMP('2022-02-22 15:00:00')) as min
from 表名 GROUP BY min asc