liuyu000 commented on a change in pull request #1837: [TRAFODION-3306] Add the TRUNC Function in the Trafodion SQL Reference Manual URL: https://github.com/apache/trafodion/pull/1837#discussion_r278794290
########## File path: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ########## @@ -12460,6 +12460,122 @@ CHAR(20). This expression uses the TRIM function to return the value TRIM(first_name) || ' ' || TRIM (last_name) ``` +[[trunc_function]] +== TRUNC Function + +The TRUNC (TRUNCATE) function truncates `_numeric-expression_` on an optional `_decimal-place_` decimal position(s), that is, it rounds down `_numeric-expression_` to the nearest (or equal) integer closer to zero *without rounding*. Review comment: For most databases, TRUNC(123,-1) gives 120, while Trafodion doesn't support negative _decimal-place_. Your suggestions are correct, I've incorporated them. Thanks again. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
