Subject Re: [ib-support] Gorup by
Author Svein Erling Tysvaer
Hi Michael,
I think you'll have to write stored procedures to do these things (well,
number 1 could be arranged by having separate fields for date and time).


At 09:25 21.02.2003 +0000, you wrote:
>I have two things my customer wants.
>In my DB there is a table containing some data of what had happend
>during some time.
>This table contains a field, definded as DATE.
>I contains both date and time.
>Now I would like to do a select like:
> MyDate
> Sum(Field1)
>from MyTable
>Group by MyDate.
>This results gives me a lot of records of the same day because of the
>I would like to eliminate the time, so to get a sum of the entire day.
>As above, but I would like to group by every hour of every day.
>My customer would like to se something like this: