1:今天明天昨天后天前天...
ORDER BY
abs(
(
to_days(`pi`.`effdate`) - to_days(now())
)
),
`pi`.`effdate` DESC
2:今天明天后天...昨天前天大前天...
ORDER BY
(`pi`.`effdate` < now()),
IF (
(`pi`.`effdate` < now()),
0,
`pi`.`effdate`
),
`pi`.`effdate` DESC