Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Computing the difference between two time values by means of SQL

  1. #11

    Question Re: Computing the difference between two time values by means of SQL

    Quote Originally Posted by susejunky View Post
    … 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?

  2. #12
    Join Date
    Sep 2014
    Location
    Germany
    Posts
    701

    Default Re: Computing the difference between two time values by means of SQL

    Quote Originally Posted by elfring View Post
    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

  3. #13

    Lightbulb Re: Computing the difference between two time values by means of SQL

    Quote Originally Posted by susejunky View Post
    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).

  4. #14
    Join Date
    Sep 2014
    Location
    Germany
    Posts
    701

    Default Re: Computing the difference between two time values by means of SQL

    Quote Originally Posted by elfring View Post
    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

  5. #15
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    3,962

    Default Re: Computing the difference between two time values by means of SQL

    Quote Originally Posted by susejunky View Post
    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 …

Page 2 of 2 FirstFirst 12

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •