MOD in postgresql - Useful SQL

 SELECT COUNT(*) FROM abc WHERE MOD(EXTRACT(DAY FROM cast("datecolumn" as timestamp))::int,2) = 1 

UPDATE abc SET datecolumn = 

CASE 

WHEN MOD(EXTRACT(DAY FROM cast("datecolumn" as timestamp))::int,2) = 0 

THEN datecolumn + MAKE_INTERVAL(YEARS := 2022 - EXTRACT(YEAR FROM datecolumn)::INTEGER)

ELSE datecolumn + MAKE_INTERVAL(YEARS := 2021 - EXTRACT(YEAR FROM datecolumn)::INTEGER) END