Hi, > SELECT count(1) FROM test WHERE date_field >= (? - 42)
That may have worked some time ago. It is definitely problematic, because the parser has a hard time detecting what data type the "?" is. Maybe in an old version the data type was guessed correctly, and now it is not... I'm afraid there was no unit test for this case. Using DATEADD is much better of course. 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.
