Metacrafter Registry

Tools

qddate

ID qddate

detector

Python library by Ivan Begtin that finds and parses dates written in many notations without being told the format. Version 1.1.0 has 151 date patterns, each with a key such as dt:date:date_2 - numeric dates with dots, slashes, hyphens or no separator, dates with a month name in 15 languages, and Chinese, Japanese and Korean dates with year, month and day units - plus generated variants with a time before or after the date. Metacrafter uses it to detect date columns and reports the key of the matching pattern as the format of the match. The registry records of these notations carry the pattern keys in mappings.qddate; this list is derived from them. Released under the BSD 3-Clause license.

Website
https://github.com/ivbeg/qddate
Supported types
35

Supported semantic types

IDNameCategoriesCountriesDescription
date Date datetime global Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype.
date_bulgarian Date with a Bulgarian month name pattern draft datetime global Calendar date written in Bulgarian with the month name, day first, for example 5 май 2022 or 25 декември 2024, optionally followed by г....
date_cjk Date with year, month and day units (Chinese, Japanese) pattern draft datetime global Calendar date written in Chinese or Japanese as numbers followed by the units for year (年), month (月) and day (日, or 号 in spoken...
date_czech Date with a Czech month name pattern draft datetime global Calendar date written in Czech with the month name, day first, usually with a dot after the day and the month in the genitive case (5....
date_dmy Date in DD.MM.YYYY notation pattern draft datetime global Calendar date written as a two-digit day, a two-digit month and a four-digit year separated by dots, such as 31.12.2022. This day-first...
date_dmy_compact Date as DDMMYYYY pattern draft datetime global Calendar date written as eight digits without separators: two-digit day, two-digit month and four-digit year, for example 25122024. A...
date_dmy_dash Date as DD-MM-YYYY pattern draft datetime global Calendar date written as day, month and four-digit year separated by hyphens, for example 25-12-2024. It is not the ISO 8601 order,...
date_dmy_dash_yy Date as DD-MM-YY pattern draft datetime global Calendar date written as day, month and two-digit year separated by hyphens, for example 25-12-24. The century is not written and has to...
date_dmy_dot_yy Date as DD.MM.YY pattern draft datetime global Calendar date written as day, month and two-digit year separated by dots, for example 25.12.24, sometimes with a dot after the year...
date_dmy_slash Date as DD/MM/YYYY pattern draft datetime global Calendar date written as day, month and four-digit year separated by slashes, for example 25/12/2024, as in the United Kingdom and...
date_dmy_slash_yy Date as DD/MM/YY pattern draft datetime global Calendar date written as day, month and two-digit year separated by slashes, for example 25/12/24. The century is not written and has to...
date_dutch Date with a Dutch month name pattern draft datetime global Calendar date written in Dutch with the month name, day first: 5 mei 2022 or 5 mrt 2022, optionally after the weekday (donderdag 5 mei...
date_english Date with an English month name pattern draft datetime global Calendar date written in English with the month name, full or abbreviated, capitalised or in lower case. The day comes first (5 May...
date_french Date with a French month name pattern draft datetime global Calendar date written in French with the month name, day first: 5 mai 2022, le 5 mai 2022, 5 sept 2022, optionally after the weekday...
date_german Date with a German month name pattern draft datetime global Calendar date written in German with the month name, day first: 5. Mai 2022, 5 Mai 2022 or 5. Mär 2022, optionally after the weekday...
date_italian Date with an Italian month name pattern draft datetime global Calendar date written in Italian with the month name, day first: 5 maggio 2022 or 5 mag 2022, optionally after the weekday (giovedì 5...
date_korean Date with year, month and day units (Korean) pattern draft datetime global Calendar date written in Korean as numbers followed by the units for year (년), month (월) and day (일), for example 2024년 12월 25일. A...
date_mdy_slash Date as MM/DD/YYYY (United States) pattern draft datetime global Calendar date written as month, day and four-digit year separated by slashes, for example 12/25/2024, the usual numeric date in the...
date_mdy_slash_yy Date as MM/DD/YY (United States) pattern draft datetime global Calendar date written as month, day and two-digit year separated by slashes, for example 12/25/24, as in the United States. The century...
date_polish Date with a Polish month name pattern draft datetime global Calendar date written in Polish with the month name, day first, usually with the month in the genitive case (5 maja 2022), optionally...
date_portuguese Date with a Portuguese month name pattern draft datetime global Calendar date written in Portuguese with the month name, day first: 5 de maio de 2022, 5 maio 2022 or 5 mai 2022, optionally after the...
date_romanian Date with a Romanian month name pattern draft datetime global Calendar date written in Romanian with the month name, day first: 5 mai 2022 or, with an abbreviated month, 5 ian. 2022. The month is...
date_russian Date with a Russian month name pattern draft datetime global Calendar date written in Russian with the month name in the genitive case, day first: 5 мая 2022, 5 мая 2022 г. or 5 мая 2022 года,...
date_slovak Date with a Slovak month name pattern draft datetime global Calendar date written in Slovak with the month name, day first, usually with a dot after the day and the month in the genitive case (5....
date_spanish Date with a Spanish month name pattern draft datetime global Calendar date written in Spanish with the month name, day first, with or without the preposition de: 5 de mayo de 2022, 5 mayo 2022, 5...
date_turkish Date with a Turkish month name pattern draft datetime global Calendar date written in Turkish with the month name, day first, for example 5 Mayıs 2022, optionally followed by tarihinde or tarihli...
date_ukrainian Date with a Ukrainian month name pattern draft datetime global Calendar date written in Ukrainian with the month name, day first: 5 травня 2022 (genitive), 5 травень 2022 (nominative) or 5 трав. 2022...
date_ymd_compact Date as YYYYMMDD pattern draft datetime global Calendar date written as eight digits without separators: four-digit year, two-digit month and two-digit day, for example 20241225. This...
date_ymd_dot Date as YYYY.MM.DD pattern draft datetime global Calendar date written as four-digit year, month and day separated by dots, for example 2024.12.25.
date_ymd_slash Date as YYYY/MM/DD pattern draft datetime global Calendar date written as four-digit year, month and day separated by slashes, for example 2024/12/25, as often written in Japan.
monthday_cjk Month and day with units (Chinese, Japanese) pattern draft datetime global Month and day without a year, written in Chinese or Japanese as numbers followed by the units for month (月) and day (日 or 号), for...
monthday_dm_dot Day and month as DD.MM pattern draft datetime global Day and month without a year, written as two two-digit numbers separated by a dot, for example 25.12. Such values look like decimal...
monthday_english Month and day with an English month name pattern draft datetime global Month and day without a year, written in English with a capitalised month name, month first (May 5, Sept. 5, Dec 25th) or day first (5...
monthday_korean Month and day with units (Korean) pattern draft datetime global Month and day without a year, written in Korean as numbers followed by the units for month (월) and day (일), for example 12월 25일. A...
monthday_russian Day and month with a Russian month name pattern draft datetime global Day and month without a year, written in Russian with the month name in the genitive case, for example 5 мая or 25 декабря.

Use this record