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).

Set

At 09:25 21.02.2003 +0000, you wrote:

>Hi
>
>I have two things my customer wants.
>
>
>1.
>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:
>
>Select
> MyDate
> Sum(Field1)
>from MyTable
>Group by MyDate.
>
>This results gives me a lot of records of the same day because of the
>time.
>I would like to eliminate the time, so to get a sum of the entire day.
>
>2.
>As above, but I would like to group by every hour of every day.
>My customer would like to se something like this: