I'm working in a project of converting an application from Syabse to
Oracle (1000 man-day).
In Sybase, the result of convert(numeric(4,2),1.2378) is 1.23
In Oracle, the result of cast(1.2378 as number(4,2)) is 1.24
I look the same thing in implicit conversion : insert number(6,4) value
in a table column of the type numeric(4,2)
How to modify the oracle behaviour (any server option ? )to do
truncation instead of rounding ? Of course I can use truncate function
but it will complicate all the obvious conversions.
Thanks.
Received on Tue Oct 25 2005 - 15:51:16 CDT
