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"
→ datetime.offset.iana

DuckDB

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

JSON Schema

finetype schema datetime.offset.iana
{
  "$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-broad-type": "VARCHAR",
  "x-finetype-transform": "{col}"
}

Examples

America/New_YorkEurope/LondonAsia/Tokyo

Aliases

timezone

Type Registry