Thanks it realy works :))

And how Can I assign string name for month? I would like that my squery
return string name for month and not number like "Januariy, February,..."

BTW: Where Can I found information on firebir "extra
functionctionalitis" like extract, mont,... Any URL? Book? I derived
that I know onely basic of firebird SQL. I am in truble every time when
I want to write some more complicates select sentence.


Luiz wrote:

>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/
>>
>>
>>
>>
>
>
>
>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/
>
>
>

--
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



[Non-text portions of this message have been removed]