Hello. You can add a cast to REAL or DOUBLE PRECISION: cast(sum(minutes) / 60 as double precision).
Actually it's a bug, it was fixed after the last published release of H2. H2 compiled from current sources returns 20.0000000000000000000000 as expected. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/51764246-8695-42cc-8948-bd3cdce8b097n%40googlegroups.com.
