Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Numeric Functions > TRUNCATE

TRUNCATE

ANSI DB2 SQL/DS XDB
      X

Truncates expr1 to the precision specified in int_expr. The format appears below:

TRUNCATE(expr, int_expr)

Can truncate to negative decimals. For example:

TRUNCATE(549.55,1) = 549.5
TRUNCATE(549.55,-1) = 540.00
TRUNCATE(549.55,-2) = 500
Parent topic: Numeric Functions
Previous Topic Next topic Print topic