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
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