sql - Months between 2 dates | postgreSQL

Question

I have 2 dates 1-Jan-18 , 1-Apr-18 and I want that by giving start and end date function returns all the month like:

jan 18
Feb 18
Mar-18
Apr-18

all the month list that lies in between the date.

question from:https://stackoverflow.com/questions/65679899/months-between-2-dates-postgresql

Answer 1

You can use generate_series but it will fail if your dates are not on the same date - e.g. if the start date is 2017-10-30 and the end date is 2018-02-28

SELECT generate_series('2018-01-01','2018-04-01',interval '1 month');