Thanks Adam! Works great. Why can't I use something like:

select cast(myfieldname as Date) as SomeName, count(*)
from mytablename
group by SomeName

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> --- In firebird-support@yahoogroups.com, "ra8009" <ra8009@y...> wrote:
> >
> > How do I group by DATE only on a timestamp field?
> >
>
> select cast(myfieldname as Date), count(*)
> from mytablename
> group by 1
>