MeridianMERIDIAN

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
Spec
https://www.iso.org/standard/70907.html

Try it

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

DuckDB

Detect
SELECT ft_infer('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(ft_cast(my_column) AS DATE) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'datetime.date.iso';

JSON Schema

finetype taxonomy datetime.date.iso -o json-schema
{
  "$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-label": "datetime.date.iso",
  "x-finetype-pii": false
}

Examples

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

Type Registry