Subject | Re: [firebird-support] SQL with Extract in Group By Clause |
---|---|
Author | Helen Borrie |
Post date | 2004-08-04T01:06:13Z |
At 09:02 PM 3/08/2004 +0000, you wrote:
them separately from the Main Downloads page at www.ibphoenix.com
/heLen
>Hello.In Firebird 1.5, yes. Read the release notes for 1.5. You can download
>
>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....
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:-) There ya go.
>this project. Will D/l and try on FB 1.51 first chance I get.
/heLen