YEAR_OF_WEEK

year

year_of_week

Description

Return to the ISO week date standard year, please refer to ISO Week date.

Alias

• yow

Syntax

SMALLINT year_of_week(DATE value)

Parameters

Parameters	Description
<value>	A date for calculate the year of week

返回值

Return to the ISO week date standard year

example

mysql> select year_of_week('2005-01-01');
+-----------------------------+
| year_of_week('2005-01-01')  |
+-----------------------------+
|                        2004 |
+-----------------------------+

keywords

YEAR_OF_WEEK