Subject Re: [ib-support] SQL query: how to group by a function
Author Rusmin Noer
From: Mirjam Besamusca <Mirjam.Besamusca@...>
> I have a SELECT statement in which I want to group the data by the month
> a date field, to calculate monthly averages. GROUP BY does not allow the
> month function though - is there any way around this?

IMHO, Why dont you make a dummy-smallint-field containing the month of the
You can make a before-post-trigger , so the dummy-field value
is always the accurate month of the date-field.

Rusmin Noer