date interval - Mailing list pgsql-novice

Hi All,

I need to generate a column representing the interval passed in months and
restrict the returned data to those intervals matching 12, 24, 36 and 48.

So far by reading the documentation I have gotten to these expressions.  But I
do not know how to get the number of months out of this.

        current_date - tbl_detail.ship_by_date AS elapsed_x
        age(tbl_detail.ship_by_date) AS elapsed_y

Once I get that I am thinking that I can use the same expression with the IN
to get the desired results.

Any help on the expressions would be appreciated.

Kind Regards,
Keith