Removing decimals in Oracle SQL

[Larshg]

Hi

I want to remove the decimals after the , in an avg calculation.

This is my script
select AVG(PROCESSED)*60
from PREPAID.RATING_REPORT
where BATCH = 600
and STARTDATE > (sysdate -12/24)

The result is something like this 21123,1677018634 I'd like it to be 21123 - that means coutting of the decimals after the ,

Please notice that it should be after the *60 to give the best result.

thanks.

/Larshg

 

[jimbopalmer]

This is my script
select TRUNC(AVG(PROCESSED)*60)
from   PREPAID.RATING_REPORT
where  BATCH = 600
and    STARTDATE > (sysdate -12/24)

or Round(AVG(PROCESSED)*60, 0) if I misunderstood I tried to remain child-like, all I acheived was childish.

 

[Larshg]

Thanks they both seem to work

Can you tell me the diference? - I can only find round in my SQL Plus guide.

/Lars

 

[jimbopalmer]

Truncate always rounds down, round will round up if it is over .5 I tried to remain child-like, all I acheived was childish.