MeridianMERIDIAN

ISO Date

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

ISO Date

datetime.date.iso

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

Domain
datetime
Category
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://meridian.online/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",
  "x-finetype-broad-type": "DATE",
  "x-finetype-format-string": "%Y-%m-%d",
  "x-finetype-transform": "strptime({col}, '%Y-%m-%d')::DATE"
}

Examples

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

Type Registry