SELECT *, abs(UNIX_TIMESTAMP(begin_time)-UNIX_TIMESTAMP('2019-04-08')) as min from ox_hand_machine_activity_device GROUP BY min desc
注 abs方法 取绝对值排序
SELECT *, abs(UNIX_TIMESTAMP(begin_time)-UNIX_TIMESTAMP('2019-04-08')) as min from ox_hand_machine_activity_device GROUP BY min desc
注 abs方法 取绝对值排序