I wrote: > I'm going to look into implementing timezone while awaiting comments on v6.
I attempted this in the attached v7. There are 4 new functions for truncating timestamptz on an interval -- with and without origin, and with and without time zone. Parts of it are hackish, and need more work, but I think it's in passable enough shape to get feedback on. The origin parameter logic was designed with timestamps-without-time-zone in mind, and retrofitting time zone on top of that was a bit messy. There might be bugs. -- John Naylor https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
v7-datetrunc_interval.patch
Description: Binary data
