首页 > itarticle > mysql date

mysql date

admin 11月 13, 2020 0

1	今天 where TO_DAYS(NOW()) = TO_DAYS(create_time)

1	昨天 and TO_DAYS(NOW()) - TO_DAYS(create_time) = 1

1	本周 and YEARWEEK(NOW()) = YEARWEEK(create_time)

1	本月 and DATE_FORMAT(NOW(),'%Y-%m') = DATE_FORMAT(create_time,'%Y-%m')

1	本年 and DATE_FORMAT(NOW(),'%Y') = DATE_FORMAT(create_time,'%Y')