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 |
| ... |
+-----------+