Options
Round value in NUMERIC instant cut off
reli
Vertica Customer ✭
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!
0
reli
Vertica Customer ✭
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!
Answers
I fount it!,
SELECT TRUNC(3.1238, 2);give the result 3.123