Looking at the HSQLDB documentation for 2.2.9, Chapter 10. Built In Functions, $Revision: 5108 $, with a date and time of: 2012-11-23 23:43:18+0000
In the documentation for, Functions for Datetime Arithmetic, for the function TRUNC ( this is for Date Time and Interval Functions, NOT Numeric Functions ), it says:
TRUNC ( <datetime value expr> )
Similar to the ROUND function, the <num value expr> is of DATE, TIME or TIMESTAMP type.
= = = = =
But, it should say:
Similar to the ROUND function, the <datetime value expr> is of DATE, TIME or TIMESTAMP type.
= = = = = = = = =
The only difference is to replace <num value expr> with <datetime value expr> after the words: Similar to the ROUND function, the
= = = = = = = =
Someone does read the documentation, and, I really appreciate the thorough documentation. Thanks so much for your efforts.
Thanks, will be fixed.