FLOOR - Query language in Cosmos DB

The FLOOR function calculates the largest integer less than or equal to the specified numeric expression.

Syntax

FLOOR(<numeric_expr>)

Arguments

Return types

Returns a numeric expression.

Examples

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

Floor of various numbers

In this example, the FLOOR function is used on positive, negative, and zero values.

SELECT VALUE {
  floorPostiveNumber: FLOOR(62.6),
  floorNegativeNumber: FLOOR(-145.12),
  floorSmallNumber: FLOOR(0.2989),
  floorZero: FLOOR(0.0),
  floorNull: FLOOR(null)
}

[
  {
    "floorPostiveNumber": 62,
    "floorNegativeNumber": -146,
    "floorSmallNumber": 0,
    "floorZero": 0
  }
]

Remarks

• STATIC-RECOMMEND-RANGE-INDEX