| Subject | Re: Group by date on a timestamp field |
|---|---|
| Author | Adam |
| Post date | 2005-12-16T05:45:52Z |
--- In firebird-support@yahoogroups.com, "ra8009" <ra8009@y...> wrote:
from mytablename
group by 1
>select cast(myfieldname as Date), count(*)
> How do I group by DATE only on a timestamp field?
>
from mytablename
group by 1