alternative - for 1y results: select date_part('year','2021-01-01'::date) - date_part('year','2020-12-31'::date) as yeardiff; yeardiff ----------

alternative - for 1y results: select date_part('year','2021-01-01'::date) - date_part('year','2020-12-31'::date) as yeardiff; yeardiff ---------- 1 (1 row)