fiscal_quarter_last_day(date)

Accepts a DateTime, DateOnly, or legacy Date object as input. Returns an object of the same type that corresponds to the last day of the fiscal quarter that contains the specified date.

Example

SELECT OrderDate as "date", fiscal_quarter_last_day(OrderDate) as "fiscal_quarter_last_day" FROM "dates_sample_data";
date fiscal_quarter_last_day
2015-01-21 15:30:00 2015-01-31 00:00:00
2015-01-21 00:00:00 2015-01-31 00:00:00
2015-01-31 10:00:30 2015-01-31 00:00:00
2015-02-03 15:30:00 2015-04-30 00:00:00
2016-01-21 23:59:59 2016-01-31 00:00:00
2015-10-31 23:59:59 2015-10-31 00:00:00
2015-12-03 00:00:00 2015-01-31 00:00:00
2016-01-11 03:30:00 2016-01-31 00:00:00
2016-01-11 03:30:00 2016-01-31 00:00:00