IBM Support

TRUNCATE() built-in function - enhanced

News


Abstract

The TRUNCATE function returns an expression truncated to some number of places to the right or left of the decimal point.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > TRUNCATE() built-in function - enhanced
See the SQL Reference for details: TRUNCATE scalar function

What's new with IBM i 7.3 and IBM i 7.2 SF99702 Level 11:

  1.  Expression-2 is optional

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11164052