[
https://issues.apache.org/jira/browse/SPARK-40945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-40945:
-----------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
