Hi, I'm sorry, JCR 2.0 doesn't support "date without time".
>select * from temp where( date >= TIMESTAMP '2010-02-01T00:00:00.000Z' > and date >= TIMESTAMP '2010-02-11T00:00:00.000Z') I believe this syntax is not supported in JCR 2.0. See also http://www.h2database.com/jcr/grammar.html The supported syntax is: select * from test where a=cast('+2001-01-01T01:02:03.000Z' as date) Regards, Thomas
