News for hackers. Stuff that matters.
Re:PostgreSQL's Missing DateDiff Function by cedricd on Tuesday December 21, 2021 @05:48PM (#29643047)
Those postgres docs are usually so dry but this is great

> The first century starts at 0001-01-01 00:00:00 AD, although they did not know it at the time

Re:PostgreSQL's Missing DateDiff Function by reidjs on Tuesday December 21, 2021 @07:41PM (#29644043)
Haha it even keeps going

> This definition applies to all Gregorian calendar countries. There is no century number 0, you go from -1 century to 1 century. If you disagree with this, please write your complaint to: Pope, Cathedral Saint-Peter of Roma, Vatican.

Re:PostgreSQL's Missing DateDiff Function by qw on Wednesday December 22, 2021 @06:09AM (#29647813)
Date and time handling is one of the areas that is surprisingly difficult, for something that appears "simple". It tends to cause a lot of frustrations, and I can see this person struggling with all the different use cases and wants the readers to know it's not their fault. Otherwise it could generate questions in support forums.