Subject Re: [firebird-support] group by date
Author Helen Borrie
At 06:39 AM 22/07/2003 -0700, you wrote:
>i have a timestamp-Field and want to group by date
>(not time!!!).
>How can i do this???
>We use FB 1.03 CS on Linux.

In Fb 1.5 you can do

select sum(amount),
cast (last_updated as date) as UpdateDate
from ledger
group by 2

But I *think* it's a 1.5 introduction. For 1.0.x, you'll need to do the
date-casting in a view and then do the grouping at run-time.