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" --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.",
  "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