Subject Re: [firebird-support] SQL with Extract in Group By Clause
Author Milan Babuskov
Lou 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....
> 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.

You can group by UDF, so use some UDF that extracts months/years from
dates. I highly recommend rFunc UDF library:


Milan Babuskov