MeridianMERIDIAN

Korean Standard Date

datetime.date.korean_ymd

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

Try a value

Korean Standard Date's rule accepts it.

Reads it as 2024-01-15

Use it

Shell
finetype infer -i '2024년 1월 15일' --mode column
# → datetime.date.korean_ymd
DuckDB
SELECT ft_infer('2024년 1월 15일');
-- → 'datetime.date.korean_ymd'
Cast template: {col} is your column
strptime(regexp_replace(regexp_replace(regexp_replace({col}, '년 ', '-'), '월 ', '-'), '일', ''), '%Y-%-m-%-d')::DATE

How finetype reads the samples

DuckDB 1.5.5 · finetype 0.6.66

ValueAs DATE
2024년 1월 15일2024-01-15
2023년 12월 25일2023-12-25
2022년 6월 1일2022-06-01

Pattern

Regular expression
^\d{4}년 [1-9]\d?월 [1-3]?\d일$
ValueLengthShape
2024년 1월 15일12matches
2023년 12월 25일13matches
2022년 6월 1일11matches
2024년 1월 1511rejected: one character short

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] 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] The Wikipedia article says the same unit-suffix rules apply when a date is written on its own.[1]

Article 43 of the Korean spelling rules says that nouns naming a unit are written with a space before them.[2] Article 43 of the Korean spelling rules allows a unit noun to be written attached when it follows a numeral.[2] Article 43 of the Korean spelling rules lists 1446년 10월 9일 among its examples of units written attached to their numerals.[2] 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]

Use

The Unicode CLDR data for Korean gives the long date format as y년 MMMM d일.[3] In the Unicode CLDR data for Korean, the wide month names are written as the number followed by 월, such as 1월 and 12월.[3]

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] Wikipedia's article says the ISO 8601 form is widely used in computing and on the Korean internet.[1]

Sources

  1. [1]Date and time notation in South Koreasecondary source
  2. [2]한국어 어문 규범standard
  3. [3]ca-gregorian.jsondataset

How it's detected

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

Schema

https://meridian.online/schemas/datetime.date.korean_ymd · Frictionless type string

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

Type Registry