Re:PostgreSQL's Missing DateDiff Function
by cedricd on Tuesday June 29, 2021 @10:37AM
(#27676393)
Author here. I've used pg a ton in the past in production systems as an operational database. Never really missed having datediff.
Once we started using it as a data warehouse I noticed that function was missing -- most other data warehouses have it. Thought it would be worth providing an implementation since date stuff is annoying to do.
Re:PostgreSQL's Missing DateDiff Function
by oncethere on Tuesday June 29, 2021 @10:52AM
(#27676640)
Interesting. Not sure I'd ever use it, but I wonder what the story is behind the data warehouses all having it but not postgres. Must be only used for data type queries.
Once we started using it as a data warehouse I noticed that function was missing -- most other data warehouses have it. Thought it would be worth providing an implementation since date stuff is annoying to do.