| Subject | Re: [firebird-support] group by date |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-07-22T14:19:58Z |
At 06:39 AM 22/07/2003 -0700, you wrote:
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.
heLen
>Hello,In Fb 1.5 you can do
>
>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.
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.
heLen