Re: [firebird-support] group by date

[Olaf Kluge check_m...@satron.de [firebird-support]]

Any ideas? 

Thank you 


Am 12. Dezember 2014 15:15:40 MEZ, schrieb "'checkmail' check_m...@satron.de 
[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
>
> 
>
> 
>
> 
>
> 

-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.