Any ideas? Thank you
Am 12. Dezember 2014 15:15:40 MEZ, schrieb "'checkmail' [email protected] [firebird-support]" <[email protected]>: >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 > > > > > > > > -- Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
