MeridianMERIDIAN

Full Month Name

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

Full Month Name

datetime.component.month_name

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

Domain
datetime
Category
component
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

Try it

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

DuckDB

Detect
SELECT ft_infer('January');
-- → 'datetime.component.month_name'
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.component.month_name';

JSON Schema

finetype taxonomy datetime.component.month_name -o json-schema
{
  "$id": "https://meridian.online/schemas/datetime.component.month_name",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Full month name. Locale-specific (January vs janvier vs Januar).",
  "enum": [
    "January",
    "February",
    "March",
    "April",
    "May",
    "June",
    "July",
    "August",
    "September",
    "October",
    "November",
    "December"
  ],
  "examples": [
    "January",
    "June",
    "December"
  ],
  "title": "Full Month Name",
  "type": "string",
  "x-finetype-label": "datetime.component.month_name",
  "x-finetype-pii": false
}

Examples

JanuaryJuneDecember

Aliases

month

Type Registry