How to query by year?

Question

PostgreSQL

The situation is simple. I'm making a small Query Builder. I need to be able to specify the years in it. It's clear that you can use this syntax: xml_date>='2015-01-01', but can you just specify the year, without having to specify days and months? Justxml_date>='2015'

Answer 1

EXTRACT