Skip to content

ISO Date

Type Registry

ISO Date

datetime.date.iso

ISO 8601 date format. The universal default for date representation in databases, APIs, and data interchange.

Domain datetime›date
Casts to DATE
Scope Universal

Try it

CLI 
$ finetype infer -i "2024-01-15"
→ datetime.date.iso

DuckDB

Detect 
SELECT finetype('2024-01-15');
-- → 'datetime.date.iso'
Cast expression 
strptime({col}, '%Y-%m-%d')::DATE
Format: %Y-%m-%d
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';

JSON Schema

finetype schema datetime.date.iso 
{
  "$id": "https://noon.sh/schemas/datetime.date.iso",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "ISO 8601 date format. The universal default for date representation in databases, APIs, and data interchange.",
  "examples": [
    "2024-01-15",
    "2019-12-31",
    "2000-01-01"
  ],
  "maxLength": 10,
  "minLength": 10,
  "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
  "title": "ISO Date",
  "type": "string"
}

Examples

2024-01-152019-12-312000-01-01

Types in datetime