Subject Re: [ib-support] Group By Month, Day, Year etc...
On 28 Mar 2002 at 23:01, lfeliz wrote:

>summary totals by month. I had been using EXTRACT w/Month and
>getting all detail and calc'ing summary using my app, but I want the
>server to do the work. Is there a UDF that does data stuff so I can
>take advantage of the GRP-By UDF in FB 1.0.

You can do it much simplier. Create a computed field and group by

As an example:

Alter table People add DMonth
computed by (Extract(Month from BirthDate));
Select DMonth, count(*) from People group by DMonth;

SY, Dimitry Sibiryakov.