Skip to main content
Question

Round value in NUMERIC instant cut off

  • April 6, 2021
  • 1 reply
  • 5 views
reli
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!

    1 reply

    reli
    Forum|alt.badge.img+1
    • reli
    • Author
    • Participating Frequently
    • April 7, 2021

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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement