Difference between EXTRACT(year from timestamp) function and date_part('year', timestamp) in PostgreSql.
Difference between EXTRACT(year from timestamp) function and date_part('year', timestamp) in PostgreSql