On Sun, 14 Dec 2014 15:46:52 +0100, "Olaf Kluge check_mail@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

> Any ideas?
>
> Thank you
>
>
> Am 12. Dezember 2014 15:15:40 MEZ, schrieb "'checkmail'
> check_mail@... [firebird-support]"
> <firebird-support@yahoogroups.com>:
>>Hello @ll,
>>
>>I would like to group my records by day or month. The date is saved as
>>timestamp. If I do the following,
>>
>>SELECT EXTRACT(day FROM m.messzeit), COUNT(*) as CountMessages
>>FROM te_messzeiten m
>>GROUP BY EXTRACT(day FROM m.messzeit)
>>
>>I get all days (1 to 31), but I need group by 1.1.2014, 2.1.2014.. -
>>daily
>>bzw. 1 2014, 2 2014 - monthly
>>
>>How can I realize this?
>>
>>Thank you
>>
>>Best regards
>>
>>Olaf

I already answered this, 5 minutes after your initial question. See
https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/125829

Mark