| Subject | AW: [firebird-support] group by date |
|---|---|
| Author | checkmail |
| Post date | 2014-12-15T08:40:43Z |
Hello Mark,
I don’t know why, but I haven’t get this e-mail. Thank you very much!
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 15. Dezember 2014 09:00
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] group by date
On Sun, 14 Dec 2014 15:46:52 +0100, "Olaf Kluge check_mail@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> Any ideas?I already answered this, 5 minutes after your initial question. See
>
> 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
https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/125829
Mark