Nevermind... I decided to supply the start and end dates as parameters rather than rely on proprietary database functions. :)
Thanks, James On Tue, Dec 14, 2010 at 6:10 PM, James Carr <[email protected]> wrote: > 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.
