Andreas,
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: http://hsqldb.org/
Version 2.2 is documented here: http://hsqldb.org/doc/guide/
Version 1.8 is the "integrated" database engine of LibreOffice. Its
documentation seems to be gone by now.
--
View this message in context:
http://nabble.documentfoundation.org/Fw-LibreO-Base-is-lying-about-my-age-tp3749948p3751931.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
