this post was submitted on 24 Dec 2023
97 points (96.2% liked)
Today I learned
7870 readers
1 users here now
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Lol I just make sure they're formatted as ISO dates or timestamps and store them as text, you can do good enough date operations on them
This. Lexical sort works on dates stored as text in ISO format. For times, better standardize in storing in UTC and converting to and from local time. Although storage will suffer as this consumes way more data than storing as number.
Yeah fuck timezones. UTC in and out please