round.asciidoc 475 B

123456789101112131415
  1. [discrete]
  2. [[esql-round]]
  3. === `ROUND`
  4. Rounds a number to the closest number with the specified number of digits.
  5. Defaults to 0 digits if no number of digits is provided. If the specified number
  6. of digits is negative, rounds to the number of digits left of the decimal point.
  7. [source.merge.styled,esql]
  8. ----
  9. include::{esql-specs}/docs.csv-spec[tag=round]
  10. ----
  11. [%header.monospaced.styled,format=dsv,separator=|]
  12. |===
  13. include::{esql-specs}/docs.csv-spec[tag=round-result]
  14. |===