select WEEKDAY('2020-07-27'),WEEK('2020-07-27'), DATE_FORMAT('2020-07-27','%Y-%u'),DATE_FORMAT('2020-07-27','%Y-%U'), WEEKOFYEAR('2020-07-27')
MYSQL周计算公式
最新推荐文章于 2024-02-03 21:40:50 发布
select WEEKDAY('2020-07-27'),WEEK('2020-07-27'), DATE_FORMAT('2020-07-27','%Y-%u'),DATE_FORMAT('2020-07-27','%Y-%U'), WEEKOFYEAR('2020-07-27')