(zettel (meta (back "00001006030000 00001012931200") (backward "00001006030000 00001012931200") (box-number "1") (created "20210212135017") (forward "00001006032000 00001007706000") (modified "20231030182858") (published "20231030182858") (role "manual") (syntax "zmk") (tags "#manual #meta #reference #zettel #zettelstore") (title "Timestamp Key Type")) (rights 4) (encoding "") (content "Values of this type denote a point in time.\n\n=== Allowed values\nMust be a sequence of 4, 6, 8, 10, 12, or 14 digits (\"\"0\"\"--\"\"9\"\") (similar to an [[Identifier|00001006032000]]), with the restriction that it must conform to the pattern \"\"YYYYMMDDhhmmss\"\".\n\n* YYYY is the year,\n* MM is the month,\n* DD is the day,\n* hh is the hour,\n* mm is the minute,\n* ss is the second.\n\nIf the sequence is less than 14 digits, they are expanded with the following rule:\n\n* YYYY is expanded to YYYY0101000000\n* YYYYMM is expanded to YYYYMM01000000\n* YYYYMMDD is expanded to YYYYMMDD000000\n* YYYYMMDDhh is expanded to YYYYMMDDhh0000\n* YYYYMMDDhhmm is expanded to YYYYMMDDhhmm00\n\n=== Query comparison\n[[Search values|00001007706000]] with more than 14 characters are truncated to contain exactly 14 characters.\nThen, they are treated as timestamp data, as describe above, if they contain 4, 6, 8, 10, or 12 digits.\n\nComparison is done through the string representation.\nIn case of the search operators \"\"less\"\", \"\"not less\"\", \"\"greater\"\", and \"\"not greater\"\", this is the same as a numerical comparison.\n\n=== Sorting\nSorting is done by comparing the possibly expanded values."))