[
https://issues.apache.org/jira/browse/TRAFODION-3306?focusedWorklogId=233244&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-233244
]
ASF GitHub Bot logged work on TRAFODION-3306:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 26/Apr/19 02:54
Start Date: 26/Apr/19 02:54
Worklog Time Spent: 10m
Work Description: liuyu000 commented on 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]
Issue Time Tracking
-------------------
Worklog Id: (was: 233244)
Time Spent: 2h (was: 1h 50m)
> Add the TRUNC Function in the Trafodion SQL Reference Manual
> ------------------------------------------------------------
>
> Key: TRAFODION-3306
> URL: https://issues.apache.org/jira/browse/TRAFODION-3306
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Priority: Major
> Fix For: 2.4
>
> Time Spent: 2h
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
