Edit

Share via

FLOOR (NoSQL query)

  • Applies to: Azure Cosmos DB for NoSQL, Cosmos DB in Fabric

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

Syntax

FLOOR(<numeric_expr>)

Arguments

Description
numeric_expr A numeric expression.

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