In v9, I've simplified the patch somewhat to make it easier for future work to build on.
- When truncating on month-or-greater intervals, require the origin to align on month. This removes the need to handle weird corner cases that have no straightforward behavior. - Remove hackish and possibly broken code to allow origin to be after the input timestamp. The default origin is Jan 1, 1 AD, so only AD dates will behave correctly by default. This is not enforced for now, since it may be desirable to find a way to get this to work in a nicer way. - Rebase docs over PG13 formatting changes. -- John Naylor https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
v9-datetrunc-interval.patch
Description: Binary data
