Subject Re: [firebird-support] SQL with Extract in Group By Clause
Author Helen Borrie
At 09:02 PM 3/08/2004 +0000, you wrote:
>Is it possible do use the Extract function to Group-By in a query?
>I periodicaly have a need to report summary totals over several
>months and the only way that seems logical is to group by Extract
>(Year from date), Extracte (month from date), sum(value) etc....

In Firebird 1.5, yes. Read the release notes for 1.5. You can download
them separately from the Main Downloads page at

>I am currently only using FB1.0x FB 1.5 is in my near future for
>this project. Will D/l and try on FB 1.51 first chance I get.

:-) There ya go.