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