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