MySQL WEEK()ฟังก์ชัน

ส่งกลับหมายเลขสัปดาห์สำหรับวันที่:

SELECT WEEK("2017-06-15");

ความหมายและการใช้งาน

ฟังก์ชัน WEEK() ส่งกลับหมายเลขสัปดาห์สำหรับวันที่กำหนด (ตัวเลขตั้งแต่ 0 ถึง 53)

WEEK(date, firstdayofweek)

Parameter	Description
date	Required. The date or datetime to extract the week number form
firstdayofweek	Optional. Specifies what day the week starts on. Can be one of the following: 0 - First day of week is Sunday 1 - First day of week is Monday and the first week of the year has more than 3 days 2 - First day of week is Sunday 3 - First day of week is Monday and the first week of the year has more than 3 days 4 - First day of week is Sunday and the first week of the year has more than 3 days 5 - First day of week is Monday 6 - First day of week is Sunday and the first week of the year has more than 3 days 7 - First day of week is Monday

Parameter

Description

date

Required. The date or datetime to extract the week number form

firstdayofweek

Optional. Specifies what day the week starts on. Can be one of the following:

0 - First day of week is Sunday
1 - First day of week is Monday and the first week of the year has more than 3 days
2 - First day of week is Sunday
3 - First day of week is Monday and the first week of the year has more than 3 days
4 - First day of week is Sunday and the first week of the year has more than 3 days
5 - First day of week is Monday
6 - First day of week is Sunday and the first week of the year has more than 3 days
7 - First day of week is Monday

ทำงานใน:	จาก MySQL 4.0

ส่งกลับหมายเลขสัปดาห์สำหรับวันที่:

SELECT WEEK("2017-10-25");

ส่งกลับหมายเลขสัปดาห์สำหรับวันที่ของระบบปัจจุบัน:

SELECT WEEK(CURDATE());