Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Thanks again for your answer - nothing to argue about because the matter is secondary. I had already read the HSQLDB v2.2 guid that you refer to. And as far as I can understand the 'yyyy' ought to be as sufficient as 'year'. Here is a copy that confirms it:

/Table 10.1. TO_CHAR, TO_DATE and TO_TIMESTAMP format elements
RRRR 4-digit year
*YYYY 4-digit year*
YY 2 digit year/
Means that LO-Base shall definitely not stop working if 'yyyy' is used -- which is also the normal format in most other calculating programs. And surely it has to do with LibreO(-Base) if it is a feature of HSQLDB that is embedded in LibreO -- I did load LibreO not HSQLDB. Go and take a look at your car. The car itself runs perfectly well without a steering wheel and the seats, but you as the user (driver) do need them; that is why they are installed (embedded) in the car.

You did not focus on my main issue: /_how to get a correct calculation result._/
Now you are wasting not only your time but also mine.
I remain waiting
Best regards
Pertti Rönnberg

On 16.2.2012 23:10, Andreas Säger wrote:
The problem has nothing to do with LibreOffice. It is a built-in function of
the HSQL database engine. I am sure that it is designed to work like this.
'yyyy' is not a valid argument for the datediff function.
This is the home page of that software:
Version 2.2 is documented here:
Version 1.8 is the "integrated" database engine of LibreOffice. Its
documentation seems to be gone by now.

View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.