MeridianMERIDIAN

Timezone Abbreviation

Short alphabetic timezone abbreviation (EST, EDT, CEST, GMT, UTC, …) — the human-readable shorthand distinct from a full IANA zone name (America/New_York) or an explicit UTC offset (UTC +05:00).

Timezone Abbreviation

datetime.offset.timezone_abbreviation

Short alphabetic timezone abbreviation (EST, EDT, CEST, GMT, UTC, …) — the human-readable shorthand distinct from a full IANA zone name (America/New_York) or an explicit UTC offset (UTC +05:00).

Domain
datetime
Category
offset
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "EST" --mode column
→ datetime.offset.timezone_abbreviation

DuckDB

Detect
SELECT ft_infer('EST');
-- → 'datetime.offset.timezone_abbreviation'
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.timezone_abbreviation';

JSON Schema

finetype taxonomy datetime.offset.timezone_abbreviation -o json-schema
{
  "$id": "https://meridian.online/schemas/datetime.offset.timezone_abbreviation",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Short alphabetic timezone abbreviation (EST, EDT, CEST, GMT, UTC, …) — the human-readable shorthand distinct from a full IANA zone name (America/New_York) or an explicit UTC offset (UTC +05: 00).",
  "examples": [
    "EST",
    "CEST",
    "GMT"
  ],
  "pattern": "^(UTC|GMT|EST|EDT|CST|CDT|MST|MDT|PST|PDT|AKST|AKDT|HST|HAST|HADT|AST|ADT|NST|NDT|CET|CEST|EET|EEST|WET|WEST|BST|IST|WAT|CAT|EAT|SAST|MSK|GST|PKT|ICT|WIB|SGT|HKT|JST|KST|AEST|AEDT|ACST|ACDT|AWST|NZST|NZDT)$",
  "title": "Timezone Abbreviation",
  "type": "string",
  "x-finetype-label": "datetime.offset.timezone_abbreviation",
  "x-finetype-pii": false
}

Examples

ESTCESTGMT

Aliases

tz_abbrevtimezone_short

Type Registry