Michael,

MVMVMD> Select
MVMVMD> MyDate
MVMVMD> Sum(Field1)
MVMVMD> from MyTable
MVMVMD> Group by MyDate.

MVMVMD> This results gives me a lot of records of the same day because of the
MVMVMD> time.
MVMVMD> I would like to eliminate the time, so to get a sum of the entire day.

MVMVMD> 2.
MVMVMD> As above, but I would like to group by every hour of every day.

MVMVMD> Is this posible ?

It could, but then we need to know which version of InterBase/Firebird
you are using. That would help trimming the reply text. ;-)
Ciao
--
Nando mailto:nandod@...