SELECT extract(quarter FROM interval '18 months'); extract --------- 3 SELECT extract(quarter FROM interval '-18 months'); extract --------- -1 SELECT extract(quarter FROM interval '-18 months -600 days'); extract --------- -1 SELECT extract(quarter FROM interval '-600 days'); extract --------- 1