[
https://issues.apache.org/jira/browse/TRAFODION-3129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16536551#comment-16536551
]
Yuan Liu commented on TRAFODION-3129:
-------------------------------------
Other databases will also trunc the value, which means, round(1234.567890,2)
will return 1234.57, round(1234.567890,4) will return 1234.5679.
> round(m,n) function does not cut the value to n digits precision
> -----------------------------------------------------------------
>
> Key: TRAFODION-3129
> URL: https://issues.apache.org/jira/browse/TRAFODION-3129
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: 2.2.0
> Reporter: Yuan Liu
> Priority: Major
> Fix For: any
>
>
> Below sql should return 123.46, but it returns 123.4600,
> >>select round(123.4567,2) from dual;
> (EXPR)
> ---------------------
> 123.4600
> --- 1 row(s) selected.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
