I am using PostgreSQL 14.5
I can classify the year by quarter using the Postgres keyword QUARTER as illustrated in the documentation just like SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-02-16 20:38:40');. And it works. The default quarter starts with January. Which makes complete sense. I.e, quarter one is composed of January, February, and March. The others follow then. But, I wanted to make the month configurable so that the quarter can start at any month.
Eg. If the month starts in April, April, May, and July would be the first quarter.
I have started writing my custom function to come up with a solution but,
Can I do this without creating a custom function?
Advertisement
Answer
Hers is it:
SELECT date_trunc('quarter', now() - interval '6 month') AS quarter