CODE EXAMPLE FOR SQL

Oracle filter date column by year

select * from table where to_char(date, 'YYYY') = '2019'