Subject Re: [ib-support] GROUP BY ON MONTH or YEAR of DATE FIELDS
Author Kubanych Tajmamat uloo
in firebird 1.0 you can group by UDF.

For example, you can use DateToStr function of rfunc UDF library (
http://polesoft.da.ru ,
http://polesoft.narod.ru/files/rfunc2.zip ,
http://polesoft.narod.ru/files/rfunc2.tar.gz )
to extract month and year using format string like
DateToStr(mytimestamp,'%Y')
or
DateToStr(mytimestamp,'%m')

Best regards,
Kubanychbek Tajmamat uloo

>there are some methods for make a SELECT with GROUP BY on a part of a
>DATE or TIMESTAMP fields?
>Something like this:
>
>SELECT ...
>FROM MY_TABLE
>...
>GROUP BY MONTH(DATE_REG), YEAR(DATE_REG)
>
>where DATE_REG are a DATE fields or TIMESTAMP fields ?
>
>
>