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

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