What is the recommended format to store date fields?
Last updated 22, Mar 2024
Question
What is the recommended format for storing date fields?
Answer
The field needs to be NUMERIC
and store UNIX Epochs in seconds. If range filtering using the date field is not required, and you'd like to tag records with a month/day in a tag field, you can use a string and index as TAG
.
References
Learn more about tags and numeric indexes.