Link Search Menu Expand Document

TO_WEEKISO

Converts any supported date or timestamp data type to a number representing the week of the year. This function adheres to the ISO 8601 standards for numbering weeks, meaning week 1 of a calendar year is the first week with 4 or more days in that year.

Syntax

TO_WEEKISO(<date>)
Parameter Description
<date> The date or timestamp to be converted into the ISO week number.

Example

Where ship_date is a column of type DATE in the table fct_orders.

SELECT
    TO_WEEKISO (ship_date)
FROM
    fct_orders;

Returns:

+-----------+
| ship_date |
+-----------+
|        33 |
|        12 |
|        18 |
|         2 |
|         1 |
|       ... |
+-----------+

Where ship_date is a column of type TEXT with values in the format _YYYY/MM/DD** _.**

SELECT
    TO_WEEKISO(CAST(ship_date AS DATE))
FROM
    fct_orders;

Returns:

+-----------+
| ship_date |
+-----------+
|        33 |
|        12 |
|        18 |
|         2 |
|         1 |
|       ... |
+-----------+