Give an example for TRUNC built in function

G.S.Sekhar · New User Joined: 19 Aug 2005 Posts: 5

Hi
Please give an example for TRUNC built in function with postive and negative values.

Thanks in advance.

Somu...

balaji81_k · Active User Joined: 29 Jun 2005 Posts: 155

hai,
trunc is the functions used to truncate all the values after it encounter the decimal point.

eg-1:

trunc(15.9)=ans(15)
trunc(-15.8)= ans(-15).
iam not sure for -ve number but for +ve is correct

Nanda Krishna · New User Joined: 30 Nov 2005 Posts: 19 Location: Bangalore

Hi,

e.g. DCL (X,Y) DECIMAL FIXED(3,2);

X = 3.32;
Y = TRUNC(X); /* Y = 3.00 */

X = - 3.32;
Y = TRUNC(X); /* Y = -3.00 */

Note: TRUNC doesn't truncate all the values after it encounter the decimal
point. It only changes the fractional part of an argument to zero.
(It may be +ve or -ve number)