In PostgreSQL you can use this:
SELECT * FROM mytable WHERE date_part('year', mydate) = date_part('year', CURRENT_DATE);
The date_part function is available in all PostgreSQL releases from current down to 7.1 (at least).
In PostgreSQL you can use this:
SELECT * FROM mytable WHERE date_part('year', mydate) = date_part('year', CURRENT_DATE);
The date_part function is available in all PostgreSQL releases from current down to 7.1 (at least).