Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Date math in HSQLDB embedded is difficult at best. You could try this method by @pierre-yves samyn in this post -> How to do basic arithmatic with dates in Libre Base queries using current_date. Have just tested and works but you must then also account for changeover in months.

My preferred solution would be to change DB's to at least a split DB with a newer HSQL thus allowing better date functions. Again, Firebird may be even better since you can simply do:

Select current_date -1 from "Table_name"

and use simple +/- calculation on the date.