DECIMAL FUNCTIONS 1

[cristi22]

hello all -
How do i convert the result of the multiplication to decimal?

SELECT QUANTITY,  (QUANTITY *RATE) AS RATE1,RATE 
FROM MEMBER_WORK_PERIOD_FUND WHERE MEMBER_KEY AND FUND='GNYPF' AND APP='HW'

dec((QUANTITY *RATE),2,2) did not work

Now the result=59.400000, should be = 59.40

thanks a lot for help!
cristi

 

[ddiamond]

Try dec((QUANTITY *RATE),4,2). The first number represents the total number of digits including the decimal place.

As a test, I ran

select dec(5.23*4.34546,4,2) from geniusdata.pm_policy_master;

I got 22.72 as my result. BTW I ran it on v8.2.

 

[cristi22]

THANKS A LOT IT WORKED!!!!