# DMY Date with Full Month (space-separated)

Key: `datetime.date.dmy_space_full`

Day FullMonth Year with space separators. Unambiguous due to named month. CLDR en-GB long format, European formal documents.

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

Format: `%d %B %Y`

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

## Use it

Shell

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

DuckDB

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

Cast template: {col} is your column

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

## Written by

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

`en` (001, 150, AE, AG, AI, AT, AU, BB, BE, BM, BS, BW, BZ, CC, CH, CK, CM, CX, CY, DE, DG, DK, DM, ER, FI, FJ, FK, FM, GB, GD, GG, GH, GI, GM, GY, HK, ID, IE, IL, IM, IN, IO, JE, JM, KE, KI, KN, KY, LC, LR, LS, MG, MO, MS, MT, MU, MV, MW, MY, NA, NF, NG, NL, NR, NU, NZ, PG, PK, PN, PW, RW, SB, SC, SD, SE, SG, SH, SI, SL, SS, SX, SZ, TC, TK, TO, TT, TV, TZ, UG, VC, VG, VU, WS, ZA, ZM, ZW) long

## Background

### Origin

In the Unicode CLDR data for British English (en-GB), the long date format of the Gregorian calendar is the pattern d MMMM y.[[1]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json)

Dates in the United Kingdom are traditionally and most commonly written in day–month–year order.[[2]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom) The Wikipedia article on UK date notation gives 31 December 1999 as an example of the day–month–year format.[[2]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom) Formal style manuals discourage writing the day of the month as an ordinal number, according to the same Wikipedia article on UK date notation.[[2]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom)

FineType defines the type datetime.date.dmy\_space\_full with the format string %d %B %Y.[[3]](https://raw.githubusercontent.com/meridian-online/finetype/main/labels/definitions_datetime.yaml) FineType's label definition describes the type as the CLDR en-GB long format.[[3]](https://raw.githubusercontent.com/meridian-online/finetype/main/labels/definitions_datetime.yaml)

### Use

The GOV.UK A to Z style guide tells writers not to use ordinal numbers for the day, giving 2 June and not 2nd June as its example.[[4]](https://guidance.publishing.service.gov.uk/writing-to-gov-uk-standards/style-guides/a-to-z-style-guide/) The GOV.UK A to Z style guide tells writers not to put a comma between the month and year, giving 4 June 2017 as its example.[[4]](https://guidance.publishing.service.gov.uk/writing-to-gov-uk-standards/style-guides/a-to-z-style-guide/) The GOV.UK A to Z style guide allows truncated months such as Jan and Feb when space is an issue, for example in tables.[[4]](https://guidance.publishing.service.gov.uk/writing-to-gov-uk-standards/style-guides/a-to-z-style-guide/)

Wikipedia's article on UK date notation says that the UK has no standard pattern for long form dates when printed.[[2]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom) The Wikipedia article on UK date notation says The Guardian, the Financial Times and The Daily Telegraph write dates as Friday 31 December 2021.[[2]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom)

Python's datetime documentation says that, with strptime(), the leading zero is optional for %d.[[5]](https://docs.python.org/3/library/datetime.html) DuckDB's date format documentation gives an example that parses 2 March 1992 with the specifier %-d followed by %B and %Y.[[6]](https://duckdb.org/docs/current/sql/functions/dateformat.html) Because month names belong to a language, confirm that a file's month names are English before parsing it with an English-locale parser, and test a few single-digit days such as 1 June 2000. (Meridian's view) A named month removes the day-or-month doubt that numeric dates carry, so once parsed, this form is one of the safer date columns to trust. (Meridian's view)

## Sources

1. [ca-gregorian.json](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/en-GB/ca-gregorian.json) — standard
2. [Date and time notation in the United Kingdom](https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom) — secondary source
3. [definitions\_datetime.yaml](https://raw.githubusercontent.com/meridian-online/finetype/main/labels/definitions_datetime.yaml) — FineType
4. [A to Z style guide - GOV.UK content and publishing guidance](https://guidance.publishing.service.gov.uk/writing-to-gov-uk-standards/style-guides/a-to-z-style-guide/) — organisation
5. [datetime — Basic date and time types](https://docs.python.org/3/library/datetime.html) — documentation
6. [Date Format Functions](https://duckdb.org/docs/current/sql/functions/dateformat.html) — documentation

## How it's detected

CLDR en-GB long format.