The Numeric TRUNC Function (Truncate)
The TRUNC function performs a truncation operation on a numeric value based on the decimal precision specified. A numeric truncation is different from rounding in that it drops the numbers beyond the decimal precision specified and does not attempt to round up or down if the decimal precision is positive. However, if the decimal precision (n) is negative, the input value is zeroed down from the nth decimal position.
The TRUNC function takes two parameters. Its syntax is TRUNC(source number, decimal precision). Source number represents any numeric value. Decimal precision specifies the degree...
- CHAPTER 10 Single-Row and Conversion Functions
- from OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM : Exams 1Z0-051, 1Z0-052, 1Z0-053
- Publisher: Oracle Press
- Released: August 2009
Revisit - Imp
Share this highlighthttp://www.safaribooksonline.com/a/ocaocp-oracle-database/1887/