Question

Round value in NUMERIC instant cut off

5 years ago
Apr 6, 2021 6:10 AM UTC
1 reply
9 views

Forum|alt.badge.img

+1

reli
Participating Frequently

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!

Forum|alt.badge.img

+1

reli
Author
Participating Frequently
5 years ago
Apr 7, 2021 8:23 AM UTC

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

Like