Using FB 1.5, something as:
select extract(month from field_date), count(*) from table1
group by extract(month from field_date)

or in early versions using a view or UDF.

Luiz.

----- Original Message -----
From: "ales" <ales@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, October 04, 2003 12:17 PM
Subject: [firebird-support] select group by month


> Helo!
>
> I would like to select data from my table grouped by month geted from
> timestamp date format. How to do this??
>
> --
> Aleš Curk :)
>
> + PETER CURK s.p. Računalniški inženiring
> + Žapuže 111, 5270 Ajdovščina
> + 05/368 16 25, 041 646 035
> + mailto:info@...
> + http://www.curk-sp.si
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>