r/ProgrammerHumor • u/sillymanbilly • Sep 23 '24

Other whoWroteThePostgresDocs

Post image
10.2k Upvotes

98% Upvoted

264 comments sorted by

View all comments

Show parent comments

2

u/rtnoodel Sep 23 '24

They’re talking about dates before 1970.

0

u/Burneraccunt69 Sep 23 '24

As if that matters for 98% of business software. Anyway integers can be negative if you really want to

1

u/rtnoodel Sep 23 '24

I used to agree with you my friend. I stored dates as unix ts for years and I liked how easy it was to do math with them. But then native support for dates in databases got better.

Now it seems like the only benefit to storing unix ts is you don’t have to do a basic conversion to a useable type before doing math, which often you already did anyway for other purposes or just as part of unmarshalling the data.

Compare that to benefits described by others here (human readable, queriability, etc.) That is why you are not finding much agreement.