# Long Date with Full Month Name

Key: `datetime.date.long_full_month`

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

Page: <https://meridian.online/docs/finetype/types/datetime/date/long_full_month>

Format: `%B %d, %Y`

Samples: `January 15, 2024`, `June 1, 2000`, `December 31, 2019`

## Use it

Shell

```shell
finetype infer -i 'January 15, 2024' --mode column
# → datetime.date.long_full_month
```

DuckDB

```sql
SELECT ft_infer('January 15, 2024');
-- → 'datetime.date.long_full_month'
```

Cast template: {col} is your column

```sql
strptime({col}, '%B %d, %Y')::DATE
-- Format: %B %d, %Y
```

## Written by

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

## Background

### Origin

In traditional American usage, dates are written in the month–day–year order, as in October 18, 2026.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_States) American styles of date notation have also influenced customs of date notation in Canada.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_States)

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]](https://www.unicode.org/reports/tr35/tr35-dates.html) The Unicode CLDR data gives English (en) the long date pattern MMMM d, y.[[3]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en/ca-gregorian.json) The CLDR full date pattern for English puts the weekday in front, as EEEE, MMMM d, y.[[3]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en/ca-gregorian.json)

### Use

Wikipedia's table of date formats gives the long format in the Philippines as mmmm d, yyyy.[[4]](https://en.wikipedia.org/wiki/Date_format_by_country) 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]](https://en.wikipedia.org/wiki/Date_format_by_country) The CLDR data for British English (en-GB) gives the long date pattern d MMMM y, with the day first.[[5]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json)

## Sources

1. [Date and time notation in the United States](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_States) — secondary source
2. [Unicode Locale Data Markup Language (LDML) Part 4: Dates](https://www.unicode.org/reports/tr35/tr35-dates.html) — standard
3. [cldr-json/cldr-dates-full/main/en/ca-gregorian.json](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en/ca-gregorian.json) — standard
4. [Date format by country](https://en.wikipedia.org/wiki/Date_format_by_country) — secondary source
5. [cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json) — standard