TRUNC function-Date Documentation Correction

Help
2012-12-06
2014-01-19
  • 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

    TRUNC ( <datetime value expr>  )

    Similar to the ROUND function, the <num value expr> is of DATE, TIME or TIMESTAMP type.

    =  = = = =

    But, it should say:

    TRUNC

    TRUNC ( <datetime value expr>  )

    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.

    Sliderule

     
  • Fred Toussi
    Fred Toussi
    2012-12-06

    Thanks, will be fixed.