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"
→ datetime.component.month_name

DuckDB

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

JSON Schema

finetype schema datetime.component.month_name
{
  "$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-broad-type": "VARCHAR",
  "x-finetype-transform": "{col}"
}

Examples

JanuaryJuneDecember

Aliases

month

Type Registry