[ https://issues.apache.org/jira/browse/SPARK-40945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17625355#comment-17625355 ]
Apache Spark commented on SPARK-40945: -------------------------------------- User 'vinodkc' has created a pull request for this issue: https://github.com/apache/spark/pull/38419 > Support built-in function to truncate numbers > --------------------------------------------- > > Key: SPARK-40945 > URL: https://issues.apache.org/jira/browse/SPARK-40945 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.4.0 > Reporter: Vinod KC > Priority: Minor > > Built-in function TRUNC shall truncate numbers to the previous integer or > decimal. It shall optionally accept a second integer argument to indicate the > number of decimal places for rounding, in either direction. When the second > argument is absent, the function rounds to the nearest whole number. When the > second argument is specified, the function rounds to the nearest number with > n decimal places of precision. > trunc ( numeric ) -> numeric > trunc ( double precision ) -> double precision > eg: > trunc(123.4382) -> 123 > trunc(-123.4382) -> -123 > trunc ( v numeric, s integer ) -> numeric > Truncates v to s decimal places > eg: > trunc(123.4382, 2) -> 123.43 > trunc(123.4382, 0) -> 123 > trunc(123.4382, -1) -> 120 > trunc(123.4382, -2) -> 100 > trunc(123.4382, -3) -> 0 > Reference : > PostgreSQL: https://www.postgresql.org/docs/15/functions-math.html > AWS Redshift: https://docs.aws.amazon.com/redshift/latest/dg/r_TRUNC.html > Presto : > https://prestodb.io/docs/current/functions/math.html?highlight=trunc#id3 -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org