Computing the difference between two time values by means of SQL

[elfring]

… LibreOffice 7.x still uses HyperSQL database engine 1.8.0.10.

Will this technical detail trigger any further software development concerns?

… the function DATEDIFF should do the job even without converting the TIME values.

Will any adjustments become more helpful also for the software documentation?

[susejunky]

Will this technical detail trigger any further software development concerns?

Will any adjustments become more helpful also for the software documentation?

Sorry but i have problems to understand what you are asking here (I'm no native English speaker!).

If your first question is how the current HyperSQL-Version of LibreOffice Base could impact your software development then all i can say is: The German LibreOffice Base manual states that there are plans to replace HSQLDB with Firebird "in the future" and the manual includes a table which shows the functional differences between those two engines.

Depending on your needs using an external database engine like mariadb or PostgreSQL might offer more flexibility and a better upgrade path.

However it would be best to consult the LibreOffice forum or mailing list on that topic.

Could you please elaborate on what you understand by "adjustments" and "become more helpful" in your second question?

Regards

susejunky

[elfring]

Could you please elaborate on what you understand by "adjustments" and "become more helpful" in your second question?

We might be looking for ways to influence the software evolution in desirable directions (besides our discussion).

[susejunky]

We might be looking for ways to influence the software evolution in desirable directions (besides our discussion).

LibreOffice is a community driven project. So if you want to help them to improve their software and/or documentation i think you will be welcome.

Regards

susejunky

[dcurtisfra]

The German LibreOffice Base manual states that there are plans to replace HSQLDB with Firebird "in the future" and the manual includes a table which shows the functional differences between those two engines.

With the current version 6.4.5.2 of LibreOffice shipping with Leap 15.2, the release notes state the following <https://wiki.documentfoundation.org/...Notes/6.4#Base> –

Firebird embedded database creation put back experimental considering the number of bugs.

• Despite, the “firebird” and “libreoffice-base-drivers-firebird” packages being installed by default …
• And, “Firebird” being mentioned in the system-wide LibreOffice configuration files …

It gets worse, the English handbooks are not available for LibreOffice 7.0 – the LibreOffice 6.4 Base handbook doesn't mention the Firebird issues – the LibreOffice 7.0 German handbook does …

• If and when differences between “HSQLDB” and “Firebird” exist then, the handbook text contain marked-up text related to the differences …