SELECT
*
FROM
TABLE
ORDER BY
abs(DATEDIFF(now(), time)) ASC
MySQL查询距离当前时间最近的记录
于 2021-04-16 17:33:05 首次发布
SELECT
*
FROM
TABLE
ORDER BY
abs(DATEDIFF(now(), time)) ASC