Round value in NUMERIC instant cut off

relireli Vertica Customer
edited April 2021 in General Discussion

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!


  • relireli Vertica Customer

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file