ORDER BY abs(DATEDIFF(时间字段名称,now())) //按照距离现在最近(天)排序 ORDER BY abs(TIMEDIFF(startTime,now())) //按照距离现在(时间)排序