1.MySQL 的 YEARWEEK 是獲取年份和周數(shù)的一個(gè)函數(shù)，函數(shù)形式為?YEARWEEK(date[,mode])

例如 2010-3-14 ，禮拜天

SELECT YEARWEEK('2010-3-14') 返回 11

SELECT YEARWEEK('2010-3-14',1) 返回 10

其中第二個(gè)參數(shù)是 mode ，具體指的意思如下：

?Mode First day of week Range Week 1 is the first week …

0 Sunday 0-53 with a Sunday in this year

1 Monday 0-53 with more than 3 days this year

2 Sunday 1-53 with a Sunday in this year

3 Monday 1-53 with more than 3 days this year

4 Sunday 0-53 with more than 3 days this year

5 Monday 0-53 with a Monday in this year

6 Sunday 1-53 with more than 3 days this year

7 Monday 1-53 with a Monday in this year

?

2. weekofyear函數(shù)是計(jì)算出當(dāng)前日期所在周數(shù)，和YEARWEEK('日期',1)的周數(shù)一致，但YEARWEEK('日期',1)在小于10的時(shí)候，不帶0

select WEEKOFYEAR('2016-2-2'); =5