Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Round value in NUMERIC instant cut off

edited April 6 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!


  • 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.