hi.. i am just wondering how to select DISTINCT all the YEARS in a dateTime field. the data in the table looks like this.


ID, datetime, eventName
1, 2008-12-01 01:10:20, test 1
2, 2007-12-01 01:10:20, test 2
3, 2008-12-01 01:10:20, test 3
4, 2006-12-01 01:10:20, test 4
5, 2008-12-01 01:10:20, test 5
6, 2007-12-01 01:10:20, test 6


i would like to return the following:

ID, datetime, eventName
1, 2008-12-01 01:10:20, test 1
4, 2006-12-01 01:10:20, test 4
6, 2007-12-01 01:10:20, test 6

does that make any sense at all??

many thanks in advance