Hi, The grammar for date / time / timestamp literals is different. See: http://www.h2database.com/html/grammar.html#date http://www.h2database.com/html/grammar.html#timestamp
db_inserted between date '2010-04-01' and date '2010-05-10' > record_disposition ='BLOCKED' and db_inserted between '01-APR-2010' > and '01-MAY-2010' Do you use this format in another database? If yes in which one? > Cannot parse timestamp constant 2010-04-01, cause: format hh:mm:ss; Could you post the *complete* exception message and stack trace please? What version of H2 do you use? I can't reproduce this problem. My test case is: drop table test; create table test(ts timestamp primary key); insert into test values(now()); select * from test where ts between '2000-04-01' and '2110-06-01' Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
