Date and time
Category ID datetime · 79 types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| age | Age PII draft | datetime | global | Age of the person or organization in years |
| bankcard_expiry | Payment card expiration date draft | finances, datetime | global | Month and year after which a payment card is no longer valid, printed on the card next to the card number. Payment card rules treat it... |
| birth_year | Year of birth PII draft | persons, pii, datetime | global | Year in which a person was born, written with four digits, for example 1984. Data sets publish it instead of the full date of birth to... |
| birthday | Birthday PII | pii, datetime | global | A birthday is the anniversary of the birth of a person, or figuratively of an institution. Birthdays of people are celebrated in... |
| 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. |
| datetime | Date and time | datetime | global | Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an... |
| day | Chinese day name draft | datetime | global | Chinese day name identifier |
| dayofmonth | Day of month draft | datetime | global | Month day, numeric value from 1 to 31 |
| dayofweek | Day of week draft | datetime | global | Week day name |
| deathday | Date of death PII | pii, datetime | global | Date of death of the person |
| duration | Time duration | datetime | global | The amount of time elapsed between two events |
| endayofweek | Day of week (in English) pattern draft | datetime | global | Day of week writtern in English |
| enmonth | Month name (English) pattern draft | datetime | global | English name of the month |
| enmonthshort | Short name of month (English) pattern draft | datetime | global | Abbreviated short English name/abbreviation of month |
| half_year | Half-year draft | datetime | global | Half of a calendar or fiscal year, written H1 for the first half (January to June of a calendar year) or H2 for the second half. |
| hidate | Hindi date format by field name draft | datetime | global | Hindi date format by field name identifier |
| ianatimezoneid | IANA Timezone ID pattern | datetime | global | Time zone identifier from the IANA time zone database (tz database), in Area/Location form, for example Europe/London. |
| indate | Indian date format by field name draft | datetime | IN | Indian date format by field name identifier |
| iso8601duration | Duration pattern | datetime | global | The amount of intervening time in a time interval and are represented by the format P[n]Y[n]M[n]DT[n]H[n]M[n]S or P[n]W as shown on the aside |
| month | Month draft | datetime | global | Month as number since start of the year. Could be from 1 to 12 |
| monthday | Month and day | datetime | global | Defines a part of a date - the month and day. Example (MM-DD). |
| 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 декабря. |
| opening_hours | Opening hours draft | datetime | global | Days and hours when an organization, office or facility is open or receives visitors, for example weekdays from 8:00 to 17:00 with a... |
| person_life_years | Years of life of a person PII draft | persons, datetime, pii | global | Years of birth and death of a person written as two four-digit years joined by a hyphen or an en dash, such as 1837–1919. A question... |
| quarter | Quarter of the year | datetime | global | A calendar quater of the year |
| ru_date_period | Date period (Russian) pattern draft | datetime | RU | Period between two dates, months or years written in Russian notation, for example "с 01.2025 по 12.2025" or "01.01.2025-31.12.2025".... |
| ru_goskatalog_date_precision | Precision of the creation date of a museum object in the Russian State Catalogue draft | datetime, government | RU | Precision with which the State Catalogue of the Museum Fund of the Russian Federation (Госкаталог) records the creation date of a museum... |
| ru_historical_dating | Historical dating in Russian draft | datetime | RU | Approximate date of creation of a historical or museum object written in Russian, with a century in Roman numerals, a millennium, a... |
| ru_month | Month name (Russian) pattern draft | datetime | RU | Name of a month in Russian in the nominative case, for example "январь" or "Февраль". |
| ru_opening_hours | Opening hours (Russian) pattern draft | datetime | RU | Opening hours written in Russian free text, as published in data.gov.ru datasets in columns such as "режим работы", "график работы" and... |
| ru_quarter | Quarter of the year (Russian) pattern draft | datetime | RU | Calendar quarter written in Russian with an Arabic or Roman number, optionally followed by the year, for example "1 квартал" or "II... |
| ru_yearmonth | Month and year (Russian) pattern draft | datetime | RU | Month written as a Russian month name followed by a year, optionally with "года" or "г.", for example "Февраль 2027 года" or "январь 2013". |
| rusdayofweek | Day of week (in Russian) pattern draft | datetime | RU | Day of week written in Russian language |
| rustimerange | Time range (Russian) pattern draft | datetime | RU | Time range written in Russian |
| sdmx_freq | SDMX frequency code (CL_FREQ) draft | datetime | global | Code from the SDMX code list CL_FREQ (agency SDMX, version 2.1) for the frequency of a time series or of data collection: A annual, S... |
| sdmx_reporting_period | SDMX reporting time period draft | datetime | global | Reporting period in SDMX statistical data and metadata, written as a four-digit year, a hyphen, a period letter and a number: A1 for the... |
| smpte_timecode | SMPTE timecode draft | media, datetime | global | Position in a video or audio recording as hours, minutes, seconds and frames (HH:MM:SS:FF), as defined by the SMPTE 12M standard and... |
| time | Time draft | datetime | global | Time of the day, like 12:00 or 10PM or 11:05 or 18:01:27 |
| timerange | Time range draft | datetime | global | Interval between two points of time, like 8:00-21:00 or 8:00AM-1:00PM. |
| timespan | Timespan | datetime | global | The TimeSpan structure represents a length of time (duration of time or elapsed time), and may be expressed as start/end,... |
| timezone | Time zone | datetime | global | A time zone is an area that observes a uniform standard time for legal, commercial and social purposes |
| unixtime | Digital timestamp (Unix time, Epoch time, Posix time) | datetime | global | Digital timestamp defined as Unix Time. It is a system for describing a point in time. It is the number of seconds that have elapsed... |
| utctimezoneoffset | UTC Timezone offset pattern | datetime | global | Difference between Coordinated Universal Time (UTC) and this timezone. |
| year | Year | datetime | global | A calendar year in western notation like 2022 or 1913 |
| year_range | Year range draft | datetime | global | Span of calendar years written as two four-digit years joined by a hyphen, such as 2019-2020. It often names a season, an academic or... |
| yearmonth | Year and month | datetime | global | Defines a part of a date - the year and month. Example YYYY-MM. |