SELECT t.* FROM T_ABLE t
ORDER BY DATE_FORMAT('2017-8-23','%m.%d') - 0.00 -
(CASE WHEN DATE_FORMAT('2017-8-23','%m.%d') - 0.00 - DATE_FORMAT(birthday,'%m.%d') > 0 THEN DATE_FORMAT(birthday,'%m.%d')+12
ELSE DATE_FORMAT(birthday,'%m.%d') END ) DESC;
例子是MySQL的,其他数据库适当修改
0 个评论
要回复文章请先登录或注册