MeridianMERIDIAN

Long Date with Full Month Name

datetime.date.long_full_month

Date with full month name. Locale-specific because month names vary by language (January vs janvier vs Januar).

Operations on this type: Parse a date or time

Try a value

Long Date with Full Month Name's rule accepts it.

Reads it as 2024-03-04

Use it

Shell
finetype infer -i 'January 15, 2024' --mode column
# → datetime.date.long_full_month
DuckDB
SELECT ft_infer('January 15, 2024');
-- → 'datetime.date.long_full_month'
Cast template: {col} is your column
strptime({col}, '%B %d, %Y')::DATE
-- Format: %B %d, %Y

How finetype reads the samples

DuckDB 1.5.5 · finetype 0.6.66

ValueAs DATE
January 15, 20242024-01-15
June 1, 20002000-06-01
December 31, 20192019-12-31
%B
full month name
%d
day of month, two digits
%Y
four-digit year

Written by

CLDR 46 via finetype 0.6.66

Each locale below writes this format with its CLDR date pattern at the styles named beside it.

en long · en (AS, BI, CA, GU, MH, MP, PH, PR, UM, VI) long

Scope
Locale-specific
Locales
EN, FR, DE, ES, IT, PT, NL, SV, DA, NO, PL, CS, RU

Pattern

Regular expression
^(?:[A-Za-z]+ \d{1,2},? \d{4}|\d{1,2}\.? [A-Za-z]+ \d{4})$
ValueLengthShape
January 15, 202416matches
June 1, 200012matches
December 31, 201917matches
January 15, 20215rejected: one character short

Background

Origin

In traditional American usage, dates are written in the month–day–year order, as in October 18, 2026.[1] American styles of date notation have also influenced customs of date notation in Canada.[1]

Unicode Technical Standard #35 says standard date patterns normally come in four types, and that the long type is the one with the wide month name.[2] The Unicode CLDR data gives English (en) the long date pattern MMMM d, y.[3] The CLDR full date pattern for English puts the weekday in front, as EEEE, MMMM d, y.[3]

Use

Wikipedia's table of date formats gives the long format in the Philippines as mmmm d, yyyy.[4] Wikipedia's table of date formats says many English-language publications in Canada use the month-day-year order, giving April 9, 2019 as an example.[4] The CLDR data for British English (en-GB) gives the long date pattern d MMMM y, with the day first.[5]

Sources

  1. [1]Date and time notation in the United Statessecondary source
  2. [2]Unicode Locale Data Markup Language (LDML) Part 4: Datesstandard
  3. [3]cldr-json/cldr-dates-full/main/en/ca-gregorian.jsonstandard
  4. [4]Date format by countrysecondary source
  5. [5]cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.jsonstandard

Schema

https://meridian.online/schemas/datetime.date.long_full_month · Frictionless type date · %B %d, %Y

finetype taxonomy datetime.date.long_full_month -o json-schema

Aliases

long_full_month_name

Type Registry