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.