MeridianMERIDIAN

IANA Timezone Name

Timezone identifier from the IANA Time Zone Database (tz database). Used in most programming languages and operating systems.

IANA Timezone Name

datetime.offset.iana

Timezone identifier from the IANA Time Zone Database (tz database). Used in most programming languages and operating systems.

Domain
datetime
Category
offset
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "America/New_York" --mode column
→ datetime.offset.iana

DuckDB

Detect
SELECT ft_infer('America/New_York');
-- → 'datetime.offset.iana'
Cast expression
{col}
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'datetime.offset.iana';

JSON Schema

finetype taxonomy datetime.offset.iana -o json-schema
{
  "$id": "https://meridian.online/schemas/datetime.offset.iana",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Timezone identifier from the IANA Time Zone Database (tz database). Used in most programming languages and operating systems.",
  "enum": [
    "America/New_York",
    "Europe/London",
    "Asia/Tokyo",
    "Australia/Sydney",
    "Pacific/Auckland",
    "America/Los_Angeles",
    "Europe/Paris",
    "Asia/Shanghai",
    "America/Chicago",
    "Europe/Berlin",
    "Asia/Singapore",
    "Africa/Cairo"
  ],
  "examples": [
    "America/New_York",
    "Europe/London",
    "Asia/Tokyo"
  ],
  "pattern": "^[A-Z][a-zA-Z]+/[A-Za-z_]+(/[A-Za-z_]+)?$",
  "title": "IANA Timezone Name",
  "type": "string",
  "x-finetype-label": "datetime.offset.iana",
  "x-finetype-pii": false
}

Examples

America/New_YorkEurope/LondonAsia/Tokyo

Aliases

timezone

Type Registry