Aijan@programming.dev to Programming@programming.dev · 4 months agoI Don't Trust My Own Codelackofimagination.orgexternal-linkmessage-square34fedilinkarrow-up1123arrow-down15
arrow-up1118arrow-down1external-linkI Don't Trust My Own Codelackofimagination.orgAijan@programming.dev to Programming@programming.dev · 4 months agomessage-square34fedilink
minus-squareAggressivelyPassive@feddit.delinkfedilinkarrow-up3·4 months agoEpochs aren’t that simple either. First of all, local time can be relevant, so you have to store timezone information somewhere anyway. Epochs are also somewhat iffy in regards to leap years or seconds. And finally: write me an SQL to retrieve all entries submitted in 2022 using just epochs. Timezones are annoying as fuck, don’t get me wrong, but simply ignoring them isn’t a solution either.
Epochs aren’t that simple either.
First of all, local time can be relevant, so you have to store timezone information somewhere anyway.
Epochs are also somewhat iffy in regards to leap years or seconds.
And finally: write me an SQL to retrieve all entries submitted in 2022 using just epochs.
Timezones are annoying as fuck, don’t get me wrong, but simply ignoring them isn’t a solution either.
deleted by creator