Hi All, I recently started using h2 for our spring enabled web app to speed up local development in place of the oracle db with great success. However I've been running into some issues with some queries that work fine in oracle but not in h2.
Specifically, I have this query that returns the expected number of records in oracle but zero in h2 despite the records being there: SELECT count(*) from click_impressions WHERE impression_date BETWEEN (sysdate - 1/24) AND (sysdate); Any ideas? I have enabled "SET MODE Oracle" as well. Thanks, James -- 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.
