Timestamp Key Type
Values of this type denote a point in time.
Allowed values
Must be a sequence of 14 digits (0
–9
) (same as an Identifier), with the restriction that is conforms to the pattern YYYYMMDDhhmmss
.
- YYYY is the year,
- MM is the month,
- DD is the day,
- hh is the hour,
- mm is the minute,
- ss is the second.
Match operator
A value matches a timestamp value, if the first value is the prefix of the timestamp value.
For example, 202102
matches 20210212143200
.
Sorting
Sorting is done by comparing the String values.
If both values are timestamp values, this works well because both have the same length.