Is there a list of SQL functions that are supported by the HSQLDB embedded database engine? I’m having problems even with functions like CONCAT.
P.S. I want to do a field split from one field containing “1/2016” to 2 fields with “1” and “2016”, so I’ll need functions like TRIM and LOCATE
The HSQLDB embedded database, fedora linux 33 or windows 10, LO 7.1
Update1: Column is TEXT [VARCHAR]
Update2: version info:
HSQL Database Engine 126.96.36.199 Sun Sep 01 22:10:46 IST 2019 version=1.8.0 hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.0 hsqldb.compatible_version=1.8.0
Update3: the data is in format: number/year. The number is 1 or 2 digits, the year is always 4 digits. No leading/trailing spaces.
Update4: I use the same ods file on 2 systems: windows 10 and linux fedora and I wrongly assumed that if I see HSQLDB on windows it’s the same on linux…