Re: Numeric precision conversion : truncation instead of rounding

Take your pick...

select cast(TRUNC(3.4567 * 100) / 100 as number(4,2)) from dual

or

select to_number(substr(to_char(3.4567,'00.0000'),1,6)) FROM DUAL Received on Wed Oct 26 2005 - 14:59:33 CDT