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
