mysql 获取离时间比较近的一条数据
SELECT
current_time_h,
current_time_c,
full_reg,
abs(
UNIX_TIMESTAMP( sync_date )- UNIX_TIMESTAMP( '2021-03-01 15:30:10' )) AS min ,sync_date
FROM
en_sync_airline_data
WHERE
full_reg = 'B-1062'
ORDER BY
min ASC
LIMIT...
原创
2021-03-02 18:45:06 ·
1390 阅读 ·
0 评论