MongoDB $ceil Operator
MongoDB provides different types of arithmetic expression operators that are used in the aggregation pipeline stages and $ceil operator is one of them. This operator is used to find the smallest integer greater than or equal to the specified number.
{ $ceil: <number> }
Here, the number is a valid expression until it resolves to a number.
- If the entered value is null, then this operator will return null.
- If the entered value is NaN, then this operator will return NaN.
- If the entered value is a missing field, then this operator will return null.
Examples:
In the following examples, we are working with:
Database: w3wiki
Collection: employee
Document: three documents that contain the details of the employees in the form of field-value pairs.
Using $ceil Operator:
In this example, we are going to find the smallest integer greater than or equal to the value of the perfoPoint field in the development department.
db.employee.aggregate([{$match: {department: "Development"}}, {$project: {perfoPoint: 1, ceilingPoint: {$ceil: "$perfoPoint"}}}])
Using $ceil Operator in the Embedded Document:
In this example, we are going to find the smallest integer greater than or equal to the value of the perfoPoint.firstMonthPoint field in the HR department.
db.employee.aggregate([{$match: {department: "HR"}}, ... {$project: {"perfoPoint.firstMonthPoint": 1, ceilingPoint: {$ceil: "$perfoPoint.firstMonthPoint"}}}])
Contact Us