Progress
SQL-92
Guide and Reference


ROUND Function

Returns the rounded value of a numeric expression.

SYNTAX

ROUND ( num_expression [, rounding_factor ] ) ; 

EXAMPLE

This example illustrates four calls to the ROUND function. In each case the num_expression is 2953861.8320. In the first call the rounding_factor is 2, in the second call the rounding_factor is -2, in the third call the rounding_factor is 0, and in the fourth call no rounding_factor is specified.

-- rounding_factor 2 returns 2953861.83
ROUND ( 2953861.8320, 2 )
 
 
-- rounding_factor -2 returns 2953900.00
ROUND ( 2953861.8320, -2 )
 
 
-- rounding_factor 0 returns 2953862.00
ROUND ( 2953861.8320, 0 )
 
 
-- No rounding_factor argument also returns 2953862.00
ROUND ( 2953861.8320 ) 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095