EventQL
Documentation Cloud Blog GitHub Download Sign In
  • 1. Getting Started
  • 2. Deployment
  • 3. Tables & Rows
  • 4. Collecting Data
  • 5. SQL Queries
    • 5.1. Functions & Operators
    • 5.2. Statements
      • 5.2.1. SELECT
      • 5.2.2. DRAW
      • 5.2.3. INSERT
      • 5.2.4. CREATE TABLE
      • 5.2.5. ALTER TABLE
      • 5.2.6. DROP TABLE
      • 5.2.7. DESCRIBE
      • 5.2.8. DESCRIBE PARTITIONS
      • 5.2.9. DESCRIBE SERVERS
      • 5.2.10. SHOW TABLES
  • 6. MapReduce Queries
  • 7. API Reference
  • 8. Drivers & Tools
  • 9. Internals
  • 10. Examples
Edit this page on GitHub
Documentation
SQL Queries
Functions & Operators

truncate

Returns the number x truncated to d decimal places. d defaults to 0 if not specified.

truncate(x)
truncate(x, d)
  • +
  • /
  • ==
  • !=
  • %
  • *
  • !
  • −
  • <
  • <=
  • >
  • >=
  • AND
  • concat
  • count
  • date_add
  • date_trunc
  • endswith
  • fnv32
  • from_timestamp
  • if
  • isnull
  • lcase
  • lowercase
  • max
  • mean
  • min
  • mod
  • or
  • pow
  • REGEXP
  • round
  • startswith
  • substr
  • substring
  • sum
  • time_at
  • to_bool
  • to_float
  • to_int
  • to_str
  • truncate
  • uppercase
  • ucase
  • usleep