Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/zhenxiangba/zhenxiangba.com/public_html/phproxy-improved-master/index.php on line 456
functions_rounding_decimal.yaml - Substrait: Cross-Language Serialization for Relational Algebra
[go: Go Back, main page]

Skip to content

functions_rounding_decimal.yaml

This document file is generated for functions_rounding_decimal.yaml. The extension URN is extension:io.substrait:functions_rounding_decimal.

Scalar Functions

ceil

Rounding to the ceiling of the value x.

Implementations:

  • ceil(x: decimal<P,S>): ->
    integral_least_num_digits = P - S + 1
    precision = min(integral_least_num_digits, 38)
    decimal?<precision, 0>
    

floor

Rounding to the floor of the value x.

Implementations:

  • floor(x: decimal<P,S>): ->
    integral_least_num_digits = P - S + 1
    precision = min(integral_least_num_digits, 38)
    decimal?<precision, 0>
    

round

Rounding the value x to s decimal places.

Implementations:

  • round(x: decimal<P,S>, s: i32, option:rounding): ->
    precision = min(P + 1, 38)
    decimal?<precision, S>
    
Options:
  • rounding ['TIE_TO_EVEN', 'TIE_AWAY_FROM_ZERO', 'TRUNCATE', 'CEILING', 'FLOOR', 'AWAY_FROM_ZERO', 'TIE_DOWN', 'TIE_UP', 'TIE_TOWARDS_ZERO', 'TIE_TO_ODD']