Subject Re: [firebird-support] group by date
Author Olaf Kluge
Any ideas?

Thank you

Am 12. Dezember 2014 15:15:40 MEZ, schrieb "'checkmail' check_mail@... [firebird-support]" <>:

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






Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.