Number Functions
- reference
March 16, 2025
Number functions are functions that are performed on a numeric field.
TRUNC(expression [, digits ])
Description
Truncates the number to the given number of integer digits to the right of the decimal point (left
if digits is negative).
Digits is zero if not given.
Example
Query
sql++SELECT
AVG(reviews.rating) / 5 AS normalizedRating,
ROUND((avg(reviews.rating) / 5), 2) AS roundedRating,
TRUNC((avg(reviews.rating) / 5), 3) AS truncRating
FROM reviews AS reviews
WHERE reviews.customerId = "customer62"
Returns
Result
json{
"results": [
{
"normalizedRating": 0.42000000000000004,
"roundedRating": 0.42,
"truncRating": 0.42
}
]
}