Subject | Re: Count Dates by Year |
---|---|
Author | ra8009 |
Post date | 2004-09-26T05:19:57Z |
Thank you very much Helen
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 04:25 AM 26/09/2004 +0000, you wrote:
>
> >I have a column that contains a date. I want to summarize the number
> >of dates per year. How can I accomplish this?
>
> Select extract(year from mydate), count(mydate)
> group by 1
>
> ./h