Round value in NUMERIC instant cut off

reli

Hi all,
if I do this : SELECT 3.1238 ::NUMERIC(10,3) ;
the result is 3.124 but in need, the result will be 3.123
how to do that?

Thank you!

reli

I fount it!, SELECT TRUNC(3.1238, 2);
give the result 3.123