Skip to content

ISO Week Date

Type Registry

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›date
Casts to DATE
Scope Universal

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://noon.sh/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"
}

Examples

2024-W032019-W52

Also known as

week_date

Types in datetime