SELECT *, abs(UNIX_TIMESTAMP(start_time)-UNIX_TIMESTAMP('2017-02-22')) as min from t_service_orders where user_id=7 GROUP BY min desc
mysql 查询最接近某时间的数据
最新推荐文章于 2024-08-06 04:24:00 发布
SELECT *, abs(UNIX_TIMESTAMP(start_time)-UNIX_TIMESTAMP('2017-02-22')) as min from t_service_orders where user_id=7 GROUP BY min desc