informix
Informix DataBlade API Programmer's Manual
DataBlade API Function Descriptions

decround()

The decround() function rounds a decimal type number to fractional digits.

Syntax

Usage

The rounding factor is 5x10-s-1. To round a value, the decround() function adds the rounding factor to a positive number or subtracts this factor from a negative number. It then truncates to s digits, as the following table shows

Value Before Round Value of s Rounded
Value
1.4 0 1.0
1.5 0 2.0
1.684 2 1.68
1.685 2 1.69
1.685 1 1.7
1.685 0 2.0
.


Informix DataBlade API Programmer's Manual, Version 9.2
Copyright © 1999, Informix Software, Inc. All rights reserved