In Postgres how to get all in between fiscal year from starting and end date.My fiscal year starting from 1st july.
Suppose i have two date,one of them is '2014-05-17' that is starting date and another date '2017-12-17' that is end date. i want to get all in between fiscal year like below format:
fiscal_year
-----------
2014-2015
2015-2016
2016-2017