3 ms·
> Just convert the date to 64 or 32 bit integer (or even less depending on the granularity and range of the dates). We use rfc3339 because there's a lot of got
by jasonwatkinspdx 7y ago
> Just convert the date to 64 or 32 bit integer (or even less depending on the granularity and range of the dates).
We use rfc3339 because there's a lot of gotchas that appear when you conflate civil timekeeping with an absolute time scale. The number of seconds in a day is not constant, and generally only known a few months ahead of a coming leap second. Civil timekeeping syntaxes can deal with this gracefully exactly because they're a structured representation rather than absolute nanos relative to some epoch.
- BubRoss 7y agoThey only need to be converted one way so that sorting is fast. You might be overthinking this.