Skip to content

IANA Timezone Name

Type Registry

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›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://noon.sh/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"
}

Examples

America/New_YorkEurope/LondonAsia/Tokyo

Also known as

timezone

Types in datetime