# Korean Standard Date

Key: `datetime.date.korean_ymd`

Year-Month-Day with Korean character delimiters and spaces. Standard in Korean government and institutional data.

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

Samples: `2024년 1월 15일`, `2023년 12월 25일`, `2022년 6월 1일`

## Use it

Shell

```shell
finetype infer -i '2024년 1월 15일' --mode column
# → datetime.date.korean_ymd
```

DuckDB

```sql
SELECT ft_infer('2024년 1월 15일');
-- → 'datetime.date.korean_ymd'
```

Cast template: {col} is your column

```sql
strptime(regexp_replace(regexp_replace(regexp_replace({col}, '년 ', '-'), '월 ', '-'), '일', ''), '%Y-%-m-%-d')::DATE
```

## Background

### Origin

Wikipedia's article on South Korean date notation calls this unit-suffix style the most formal way of writing a date and time.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_South_Korea) The Wikipedia article gives 1975년 7월 14일 오전 9시 18분 32초 as the unit-suffix form of the timestamp 1975-07-14 09:18:32.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_South_Korea) The Wikipedia article says the same unit-suffix rules apply when a date is written on its own.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_South_Korea)

Article 43 of the Korean spelling rules says that nouns naming a unit are written with a space before them.[[2]](https://korean.go.kr/kornorms/regltn/regltnView.do?regltn_code=0001&regltn_no=187) Article 43 of the Korean spelling rules allows a unit noun to be written attached when it follows a numeral.[[2]](https://korean.go.kr/kornorms/regltn/regltnView.do?regltn_code=0001&regltn_no=187) Article 43 of the Korean spelling rules lists 1446년 10월 9일 among its examples of units written attached to their numerals.[[2]](https://korean.go.kr/kornorms/regltn/regltnView.do?regltn_code=0001&regltn_no=187) The commentary to the Korean spelling rules explains that years, months, days and clock times may be attached because they express an order or sequence.[[2]](https://korean.go.kr/kornorms/regltn/regltnView.do?regltn_code=0001&regltn_no=187)

### Use

The Unicode CLDR data for Korean gives the long date format as y년 MMMM d일.[[3]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/ko/ca-gregorian.json) In the Unicode CLDR data for Korean, the wide month names are written as the number followed by 월, such as 1월 and 12월.[[3]](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/ko/ca-gregorian.json)

Wikipedia's article says South Korea also recognises the ISO 8601 form YYYY-MM-DD under the standard KS X ISO 8601, formerly KS X 1511.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_South_Korea) Wikipedia's article says the ISO 8601 form is widely used in computing and on the Korean internet.[[1]](https://en.wikipedia.org/wiki/Date_and_time_notation_in_South_Korea)

## Sources

1. [Date and time notation in South Korea](https://en.wikipedia.org/wiki/Date_and_time_notation_in_South_Korea) — secondary source
2. [한국어 어문 규범](https://korean.go.kr/kornorms/regltn/regltnView.do?regltn_code=0001&regltn_no=187) — standard
3. [ca-gregorian.json](https://raw.githubusercontent.com/unicode-org/cldr-json/main/cldr-json/cldr-dates-full/main/ko/ca-gregorian.json) — dataset

## How it's detected

Korean standard date with Unicode delimiters. Transform strips Korean characters and parses as ISO-like.