SELECT * from table where date > CURRENT_DATE - INTERVAL '3 months'
CURRENT_DATE - INTERVAL '6 months'