FLOOR - Query language in Cosmos DB (in Azure and 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