Timestamp Key Type

Values of this type denote a point in time.

Allowed values

Must be a sequence of 4, 6, 8, 10, 12, or 14 digits (“0”–“9”) (similar to an Identifier), with the restriction that it must conform 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.

If the sequence is less than 14 digits, they are expanded with the following rule:

• YYYY is expanded to YYYY0101000000
• YYYYMM is expanded to YYYYMM01000000
• YYYYMMDD is expanded to YYYYMMDD000000
• YYYYMMDDhh is expanded to YYYYMMDDhh0000
• YYYYMMDDhhmm is expanded to YYYYMMDDhhmm00

Query comparison

Search values with more than 14 characters are truncated to contain exactly 14 characters. Then, they are treated as timestamp data, as describe above, if they contain 4, 6, 8, 10, or 12 digits.

Comparison is done through the string representation. In case of the search operators “less”, “not less”, “greater”, and “not greater”, this is the same as a numerical comparison.

Sorting

Sorting is done by comparing the possibly expanded values.