Subject Re: [firebird-support] SQL with Extract in Group By Clause
Author Helen Borrie
At 09:02 PM 3/08/2004 +0000, you wrote:
>Hello.
>
>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 www.ibphoenix.com


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

/heLen