TRUNC (NoSQL query)

The TRUNC function returns a numeric value truncated to the closest integer value.

An Azure Cosmos DB for NoSQL system function that returns a truncated numeric value.

Syntax

TRUNC(<numeric_expr>)

Arguments

Return types

Returns a numeric expression.

Examples

This section contains examples of how to use this query language construct.

Truncate numbers to integer

In this example, the TRUNC function is used to truncate various numbers to their integer part.

SELECT VALUE {
  truncateFloatingPoint: TRUNC(2.37),
  truncateNegative: TRUNC(-2.78),
  truncateInteger: TRUNC(2),
  truncateSmallNumber: TRUNC(0.0000714),
  truncatePi: TRUNC(PI())
}

[
  {
    "truncateFloatingPoint": 2,
    "truncateNegative": -2,
    "truncateInteger": 2,
    "truncateSmallNumber": 0,
    "truncatePi": 3
  }
]

Remarks

• This function benefits from the use of a range index. For more information, see range indexes.