YEAR

Returns the year part of a value. The argument must be a date, timestamp, date duration, or timestamp duration.

Example:

Select all the projects in the PROJECT table that are scheduled to start (PRSTDATE) and end (PRENDATE) in the same calendar year.

       SELECT * FROM PROJECT
         WHERE YEAR(PRSTDATE) = YEAR(PRENDATE)