Subject group by date
Author checkmail

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