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 > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/j8k93hrU4I4J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
