Parse year from SQL Date

Question

I'm currently writing a Java app that interfaces with a MySQL database.
My problem is that I'm trying to write a function that fills a JComboBox with the unique year-values registered in the database.
I could use UNIQE on the date-field in the SQL query, but that would only exclude some of the dates, not all-but-one-date-per-year.
Any help would be greatly appreciated.

Answer 1

Use the year function

Answer 2

SELECT DISTINCT YEAR(yourDateColumn) FROM yourTable;