Date and time
ID datetime
DatatypeNot PII
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 offset), and the RFC 3339 variant with a space instead of T. Some data sets store plain dates as timestamps at midnight local time, for example 2021-05-24T21:00:00.000Z for 25 May 2021 in Moscow.
- Categories
- Date and time
- Countries
- Global (not tied to a country)
- Languages
- Common to most languages
- AutoType benchmark
date-R,date-chinese2,date-f,date-g,date-german,date-mixed,date-o,date-s,date-spanish,date-u,date5,date6,date7,date8,date9- D3M
http://schema.org/DateTime- Quality
- 100/100
- Metacrafter rules
- 6 rules (5 by field name, 1 by value)
datetimeknownfield, common/dateandtime.yamldedatetimenamefield, de/de_datetime.yamlesdatetimenamefield, es/es_datetime.yamlfrdatetimenamefield, fr/fr_datetime.yamlnldatetimepatterndata, nl/nl_datetime.yamlrusdatetimenamefield, ru/ru_datetime.yaml
- Supported by tools
- Alteryx Designer Cloud, Auctus, Auto-Type, Amazon Comprehend, Collibra Data Classification, csv-detective, Dataiku DSS, DataPrep, Capital One DataProfiler, Google Data Studio, Metabase, metacrafter, metacrafterpro, Talend (Qlik Talend Data Preparation, Data Catalog and Data Inventory), Alteryx Woodwork
Regular expression
^\d{4}-(?:0[1-9]|1[0-2])-(?:0[1-9]|[12]\d|3[01])[T ](?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:[.,]\d+)?)?(?:Z|[+-](?:[01]\d|2[0-3])(?::?[0-5]\d)?)?$Python re syntax.
Examples
| Value | Description |
|---|---|
| 2024-08-30T12:00:00.000Z | UTC timestamp with milliseconds |
| 2018-10-10T12:58:52Z | |
| 2024-11-29 12:00:00 | Space separator, as allowed by RFC 3339 |
| 2019-07-19T09:00:00+03:00 | Local time with an offset |
| 2024-08-30 invalid | A date without a time is the datatype date |
Translations
| Language | Name | Description |
|---|---|---|
| Russian | Дата и время | Дата и время суток. Регулярное выражение описывает форму ISO 8601 ГГГГ-ММ-ДДTчч:мм[:сс[.fff]] с необязательным часовым поясом (Z или смещение) и вариант RFC 3339 с пробелом вместо T. |
Sources
- wikipedia: https://en.wikipedia.org/wiki/Date_and_time_notation
- wikipedia: https://en.wikipedia.org/wiki/ISO_8601
- schema.org: https://schema.org/DateTime
Use this record
- Page URL:
http://registry.apicrafter.io/datatype/datetime - JSON: API v1 · legacy shape (used by metacrafter) · Markdown (for LLMs)
- Improve it: edit
data/datatypes/any/datetime/datetime.yamlon GitHub