Re: Min/Max + Group by date range

[Johannes Schneider]

Okay, I worked around this issue by using "floor". That seems to be good enough..

Am Dienstag, 17. Juli 2012 10:11:53 UTC+2 schrieb Johannes Schneider:

Hi guys,

I have a lot of key/value pairs. The keys are milliseconds, the values are doubles.

Now I want to find the min/max for a given time period (e.g. one day).

In MySQL I could do something like that:

group by unix_timestamp(timestamp) div (3600*24)

Any hints how I could solve that with H2?

Thanks,

Johannes