--今天

DATE_FORMAT(BIRTH_DATE,'%Y-%m-%d') = CURDATE()

--明天

DATE_FORMAT(BIRTH_DATE,'%Y-%m-%d') = TIMESTAMPADD(DAY,1,CURDATE())

--本周

YEARWEEK(DATE_FORMAT(BIRTH_DATE,'%Y-%m-%d')) = YEARWEEK(CURDATE())

--下周

YEARWEEK(DATE_FORMAT(BIRTH_DATE,'%Y-%m-%d')) = YEARWEEK(CURDATE()) + 1

--本月

DATE_FORMAT(BIRTH_DATE,'%Y-%m') = DATE_FORMAT(CURDATE(),'%Y-%m')

--下月

TIMESTAMPDIFF(MONTH,CURDATE(),BIRTH_DATE) = 1

--周年(当日)

DATE_FORMAT(REGISTE_DATE,'%m-%d') = DATE_FORMAT(CURDATE(),'%m-%d')

--周年(明日)

DATE_FORMAT(REGISTE_DATE,'%m-%d') = DATE_FORMAT(TIMESTAMPADD(DAY,1,CURDATE()),'%m-%d')

--周年(本周)

WEEK(REGISTE_DATE) = WEEK(CURDATE())

--周年(下周)

WEEK(REGISTE_DATE) = WEEK(CURDATE()) + 1

--周年(本月)

MONTH(REGISTE_DATE) = MONTH(CURDATE())

--周年(下月)

MONTH(REGISTE_DATE) = MONTH(CURDATE()) + 1

TIMESTAMPDIFF,TIMESTAMPADD 可以用 DATEDIFF,DATE_ADD替换

05-26 20:42