Re: [SQL] distinct date problem

2001-02-26 Thread Michael Fork
This should work: SELECT distinct(date_part('year', )) FROM <>; Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Sun, 25 Feb 2001, Lotus118 wrote: > Hi, > I'm having difficulty figuring this one out: > I have a table with record entries which all have a

[SQL] distinct date problem

2001-02-26 Thread Lotus118
Hi, I'm having difficulty figuring this one out: I have a table with record entries which all have a date attribute, looking something like '2000-11-11'. What I want from my data base is a list of all the years that are present in this attribute in the relation. So for example, if I had a cou