Subject | Re: [ib-support] GROUP BY ON MONTH or YEAR of DATE FIELDS |
---|---|
Author | Kubanych Tajmamat uloo |
Post date | 2003-01-17T11:33:15Z |
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
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 ?
>
>
>