All entries for Friday 24 February 2006

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 :)

: 24 Feb 2006 10:25 |  Tags: Hsqldb |  Comments (0) |  Close comments |  Report a problem