MeridianMERIDIAN

Full Month Name

datetime.component.month_namewas date.month in v1

Full month name. Locale-specific (January vs janvier vs Januar).

Casts to
VARCHAR
Scope
Locale-specific
Locales
EN, FR, DE, ES, IT, PT, AR, BG, CS, DA, EL, ET, FI, HR, HU, LT, LV, NL, NO, PL, RO, RU, SK, SL, SV, TR, UK
Per-locale rule
AR12 values, e.g. يناير, فبراير, مارس
BG12 values, e.g. януари, февруари, март
CS12 values, e.g. ledna, února, března
DA12 values, e.g. januar, februar, marts
DE12 values, e.g. Januar, Februar, März
EL12 values, e.g. Ιανουαρίου, Φεβρουαρίου, Μαρτίου
EN12 values, e.g. January, February, March
ES12 values, e.g. enero, febrero, marzo
ET12 values, e.g. jaanuar, veebruar, märts
FI12 values, e.g. tammikuuta, helmikuuta, maaliskuuta
FR12 values, e.g. janvier, février, mars
HR12 values, e.g. siječnja, veljače, ožujka
HU12 values, e.g. január, február, március
IT12 values, e.g. gennaio, febbraio, marzo
LT12 values, e.g. sausio, vasario, kovo
LV12 values, e.g. janvāris, februāris, marts
NL12 values, e.g. januari, februari, maart
NO12 values, e.g. januar, februar, mars
PL12 values, e.g. stycznia, lutego, marca
PT12 values, e.g. janeiro, fevereiro, março
RO12 values, e.g. ianuarie, februarie, martie
RU12 values, e.g. января, февраля, марта
SK12 values, e.g. januára, februára, marca
SL12 values, e.g. januar, februar, marec
SV12 values, e.g. januari, februari, mars
TR12 values, e.g. Ocak, Şubat, Mart
UK12 values, e.g. січня, лютого, березня

Background

Origin

FineType defines the full month name as its own type, datetime.component.month_name, and describes it as locale-specific, giving January, janvier and Januar as examples.[1]

Use

Unicode's LDML date standard distinguishes a format form of the month name, used within a complete date format, from a stand-alone form, used when the month is displayed by itself.[2] Unicode's LDML date standard says the stand-alone form of a month name is typically the nominative.[2] Unicode's LDML date standard notes that, depending on the language, patterns that combine month with day of month may require the month to be in genitive form.[2]

Sources

  1. [1]finetype/labels/definitions_datetime.yaml at main · meridian-online/finetypeFineType
  2. [2]Unicode Locale Data Markup Language (LDML) Part 4: Datesstandard

Detection notes

v1 name: date.month. Enum shown is EN only — each locale has its own enum.

Use it

CLI · DuckDB
$ finetype infer -i "January" --mode column
→ datetime.component.month_name

SELECT ft_infer('January');
-- → 'datetime.component.month_name'
Cast expression
{col}

Schema

https://meridian.online/schemas/datetime.component.month_name · Frictionless type string

finetype taxonomy datetime.component.month_name -o json-schema

Aliases

month

Type Registry