round.asciidoc 385 B

123456789101112
  1. [[esql-round]]
  2. === `ROUND`
  3. Rounds a number to the closest number with the specified number of digits.
  4. Defaults to 0 digits if no number of digits is provided. If the specified number
  5. of digits is negative, rounds to the number of digits left of the decimal point.
  6. [source,esql]
  7. ----
  8. FROM employees
  9. | PROJECT first_name, last_name, height
  10. | EVAL height = ROUND(height * 3.281, 1)
  11. ----