Hello everyone, I’m still learning how to use libre office base and I need help with what can I do with the embedded HSQLSBD. I’ve tried to use DATE_ADD and apparently it’s not available. Where can find a complete list of available functions to embedded HSQLBD.
Chapter 9. SQL Syntax (version 1.8 of 2006)
DATEADD is desparately missing.
Workaround: SELECT DATEDIFF( 'dd', '1899-12-30', "DateColumn" ) + 90 AS "Plus 90 Days" FROM "somewhere
This works because LibreOffice can interprete the returned number of days since 1899-12-30 as a date value. Cells in spreadsheets and text tables work this way. Just format the field as date when using it in forms and reports.
It is not too difficult to convert an embedded HSQL 1.8 into an external HSQL 2.4 which provides DATEADD, regular expressions, array functions, better perfomance and a lot more safety for your data. When any LibreOffice component crashes while using an embedded HSQL, you may lose the entire database.
1 Like
You could also use the internal Firebird database instead.
Have a look at English documentation of LO, special the Base Guide.
2 Likes