We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Round value in NUMERIC instant cut off — Vertica Forum

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!

Answers

  • relireli Vertica Customer ✭

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...