psql select 3 months from current month code example
Example: postgres select from last 3 months
SELECT * from table where date > CURRENT_DATE - INTERVAL '3 months'
SELECT * from table where date > CURRENT_DATE - INTERVAL '3 months'