query provide the current year

cast(extract(year,current_date), varchar(4)) 

cast(
  extract(year,_add_years(current_date, -1)), 
  varchar(4)
   )

cast(
  extract(year,_add_years(current_date, -2)), 
  varchar(4)
   )