# Full Weekday with Full Month Name

Key: `datetime.date.weekday_full_month`

Full weekday name followed by full month name. The most human-readable date format. Locale-specific.

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

Format: `%A, %B %d, %Y`

Samples: `Monday, January 15, 2024`, `Tuesday, December 31, 2019`

## Use it

Shell

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

DuckDB

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

Cast template: {col} is your column

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

## Written by

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

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

## Background

### Origin

Unicode's LDML specification says standard date patterns are normally provided in four types: full (usually with weekday name), long, medium and short.[[1]](https://unicode.org/reports/tr35/tr35-dates.html) LDML's own example of a full-length date pattern is EEEE, MMMM d, y.[[1]](https://unicode.org/reports/tr35/tr35-dates.html) The Unicode CLDR data gives English (en) the full date pattern EEEE, MMMM d, y.[[2]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en/ca-gregorian.json) CLDR's British English (en-GB) data puts the day first instead, with the full date pattern EEEE, d MMMM y.[[3]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json)

Wikipedia describes month–day–year order, as in October 18, 2026, as the traditional usage in the United States.[[4]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_States)

### Use

.NET's long date (D) format specifier writes 2009-06-15 as Monday, June 15, 2009 in the en-US culture.[[5]](https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings) When you meet this shape, check the source system's locale before you trust the order and the names. (Meridian's view)

In Python's strftime and strptime, %A is the weekday as the locale's full name.[[6]](https://docs.python.org/3/library/datetime.html) In Python's strftime and strptime, %B is the month as the locale's full name.[[6]](https://docs.python.org/3/library/datetime.html) Python's strptime treats the leading zero as optional for %d.[[6]](https://docs.python.org/3/library/datetime.html) Set the parsing locale explicitly rather than relying on the machine's default. (Meridian's view) Do not assume the day is zero-padded; parse with a format that accepts both 5 and 05. (Meridian's view) Treat the weekday as a free consistency check: recompute it from the parsed date and flag any row where the two disagree. (Meridian's view) Convert the column to a real date before you sort or compare it. (Meridian's view)

## Sources

1. [Unicode Locale Data Markup Language (LDML) Part 4: Dates](https://unicode.org/reports/tr35/tr35-dates.html) — standard
2. [ca-gregorian.json](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en/ca-gregorian.json) — documentation
3. [ca-gregorian.json](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json) — documentation
4. [Date and time notation in the United States](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_States) — secondary source
5. [Standard date and time format strings - .NET \| Microsoft Learn](https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings) — documentation
6. [datetime — Basic date and time types](https://docs.python.org/3/library/datetime.html) — documentation