ISO Week Date

datetime.date.iso_week

ISO 8601 week date format (YYYY-Www). Used in business planning, fiscal calendars, and European retail analytics.

Domain

datetime

Try it

CLI

$ finetype infer -i "2024-W03"
→ datetime.date.iso_week

DuckDB

Detect

SELECT finetype('2024-W03');
-- → 'datetime.date.iso_week'

Cast expression

strptime({col} || '-1', '%G-W%V-%u')::DATE
-- Format: %G-W%V

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS DATE) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'datetime.date.iso_week';

JSON Schema

finetype schema datetime.date.iso_week

{
  "$id": "https://meridian.online/schemas/datetime.date.iso_week",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "ISO 8601 week date format (YYYY-Www). Used in business planning, fiscal calendars, and European retail analytics.",
  "examples": [
    "2024-W03",
    "2019-W52"
  ],
  "pattern": "^\\d{4}-W\\d{1,2}$",
  "title": "ISO Week Date",
  "type": "string",
  "x-finetype-broad-type": "DATE",
  "x-finetype-format-string": "%G-W%V",
  "x-finetype-transform": "strptime({col} || '-1', '%G-W%V-%u')::DATE"
}

Examples

2024-W032019-W52

Aliases

week_date