MeridianMERIDIAN

Dot YMD Timestamp (24h)

datetime.timestamp.dot_ymd_24h

Dot-separated Year.Month.Day with space and 24-hour time. Niche format found in some East Asian and Baltic systems.

Operations on this type: Parse a date or time

Try a value

Dot YMD Timestamp (24h)'s rule accepts it.

Reads it as 2024-03-04 05:06:07

Use it

Shell
finetype infer -i '2024.01.15 14:30:00' --mode column
# → datetime.timestamp.dot_ymd_24h
DuckDB
SELECT ft_infer('2024.01.15 14:30:00');
-- → 'datetime.timestamp.dot_ymd_24h'
Cast template: {col} is your column
strptime({col}, '%Y.%m.%d %H:%M:%S')
-- Format: %Y.%m.%d %H:%M:%S

How finetype reads the samples

DuckDB 1.5.5 · finetype 0.6.66

ValueAs TIMESTAMP
2024.01.15 14:30:002024-01-15 14:30:00
2023.12.31 23:59:592023-12-31 23:59:59
2024.06.01 08:15:302024-06-01 08:15:30
%Y
four-digit year
%m
month, two digits
%d
day of month, two digits
%H
hour, 24-hour clock
%M
minutes
%S
seconds

Pattern

Regular expression
^\d{4}\.\d{2}\.\d{2} \d{2}:\d{2}:\d{2}$
ValueLengthShape
2024.01.15 14:30:0019matches
2023.12.31 23:59:5919matches
2024.06.01 08:15:3019matches
2024.01.15 14:30:018rejected: one character short

Background

Origin

FineType defines this type itself, with the format string %Y.%m.%d %H:%M:%S: a four-digit year, two-digit month and two-digit day joined by dots, then a space and a 24-hour time with seconds.[1]

Writing the year first with dots between the parts has national roots: Wikipedia's list of date formats by country gives Hungary's form as yyyy. mm. (d)d.[2] Wikipedia's list of date formats by country says that in South Korea many people casually write dates as (yy)yy.(m)m.(d)d(.), although the national standard format is yyyy-mm-dd.[2]

Java's SimpleDateFormat documentation uses a dotted year-first pattern in its own examples, showing yyyy.MM.dd G 'at' HH:mm:ss z formatting as 2001.07.04 AD at 12:08:56 PDT.[3]

Use

The MQL5 TimeToString function converts a time value into a string of yyyy.mm.dd hh:mi format by default.[4] The MQL5 reference says the TIME_SECONDS flag of TimeToString gets the time as hh:mi:ss.[4] When dotted year-first timestamps turn up in trading data, it is worth asking whether they came from code written in MQL5, and checking whether seconds were kept at all. (Meridian's view)

Wikipedia's article on date notation in South Korea says government documents shorten a date by replacing each unit suffix with a single period, writing 2001. 11. 29. with intervening spaces and a trailing period.[5]

Sources

  1. [1]finetype/labels/definitions_datetime.yamlFineType
  2. [2]List of date formats by countrysecondary source
  3. [3]SimpleDateFormat (Java Platform SE 8 )documentation
  4. [4]TimeToString - Conversion Functions - MQL5 Referencedocumentation
  5. [5]Date and time notation in South Koreasecondary source

How it's detected

Low prevalence. East Asian/Baltic niche.

Schema

https://meridian.online/schemas/datetime.timestamp.dot_ymd_24h · Frictionless type datetime · %Y.%m.%d %H:%M:%S

finetype taxonomy datetime.timestamp.dot_ymd_24h -o json-schema

Type Registry