Home » MySQL week() Function

MySQL week() Function

by Online Tutorials Library

MySQL Date/Time week() Function

The week() is a MySQL date/time function. It is used to get the week portion from given date.

Syntax

Parameter:

Date_value : date for getting week

Mode : it is optional. It is used to specify what day the week starts on. It can be one of the following:

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

Returns:

This function returns the week portion of a date value.

Example 1

Output:

MySQL Datetime week() Function

Example 2

Output:

MySQL Datetime week() Function

Next TopicMySQL datetime

You may also like