hsqldb + dates suck :(, but fixed in latest version :)
Writing about web page http://www.hsqldb.org/
So I was using a fairly old version of hsqldb and was doing some unit tests of my DAO which was selecting some rows based on a date column <= someDate.
Unforunately it behaved in the exact opposite way I was expecting :( If someDate was later than the value in the database column then you would expect dateColumn <= someDate to evaluate to true. But no, it didn't. It evaluated to false. Changing the condition to dateDolumn >= someDate evaluated to true!
And yes, timezones etc. were the same :)
Oh well, at least it was consistently wrong.
Upgrading to the latest hsqldb fixed it, and it was fun while it lasted :)