YEAROFWEEK

yearofweek(expr)

Description

The YEAROFWEEK function is used to return the ISO week-numbered year corresponding to a given date (expr). The ISO week-numbered year is calculated according to the international standard ISO 8601, which sets the first day of each week as Monday.

Parameter Description

• expr: The input date or timestamp, of type date or timestamp_ltz.

Return Result

Returns an integer value representing the ISO week-numbered year of the given date.

Example

1. Get the ISO week-numbered year based on the current time:

SELECT YEAROFWEEK(NOW()) as res; +------+ | res | +------+ | 2025 | +------+

2. Calculate the ISO week number year for a specified date:

SELECT YEAROFWEEK('2022-03-31')as res; +------+ | res | +------+ | 2022 | +------+

3. Calculate the ISO week number year for a given timestamp:

SELECT YEAROFWEEK(TIMESTAMP "2022-03-31 03:21:00")as res; +------+ | res | +------+ | 2022 | +------+

4. Calculate and compare the ISO week number years of two different dates:

SELECT YEAROFweek('2022-03-31') AS year1, YEAROFweek('2023-03-31') AS year2; +-------+-------+ | year1 | year2 | +-------+-------+ | 2022 | 2023 | +-------+-------+