$toLong (aggregation)

Definition定义

$toLong

New in version 4.0.在版本4.0中新增。

Converts a value to a long. 将值转换为long。If the value cannot be converted to a long, $toLong errors. 如果无法将值转换为long，则$toLong错误。If the value is null or missing, $toLong returns null.如果值为null或缺失，$toLong将返回null。

$toLong has the following syntax:语法如下：

{
   $toLong: <expression>
}

The $toLong takes any valid expression.$toLong接受任何有效表达式。

The $toLong is a shorthand for the following $convert expression:$toLong是以下$convert表达式的简写：

{ $convert: { input: <expression>, to: "long" } }

Tip提示

See also: 参阅：

$convert

Behavior行为

The following table lists the input types that can be converted to a decimal:下表列出了可以转换为小数的输入类型：

The following table lists the input types that can be converted to a long:下表列出了可以转换为long的输入类型：

The following table lists some conversion to long examples:下表列出了一些转换为长示例的示例：

Example示例

Create a collection orders with the following documents:使用以下文档创建集合orders：

db.orders.insertMany( [
   { _id: 1, item: "apple", qty: NumberInt(5) },
   { _id: 2, item: "pie", qty: "100" },
   { _id: 3, item: "ice cream", qty: NumberLong("500") },
   { _id: 4, item: "almonds", qty: "50" },
] )

The following aggregation operation on the orders collection converts the qty to long before sorting by the value:orders集合上的以下聚合操作在按值排序之前将数量转换为long：

// Define stage to add convertedQty field with converted qty value
qtyConversionStage = {
   $addFields: {
      convertedQty: { $toLong: "$qty" }
   }
};
// Define stage to sort documents by the converted qty values
sortStage = {
   $sort: { "convertedQty": -1 }
};
db.orders.aggregate( [
   qtyConversionStage,
   sortStage
])

The operation returns the following documents:该操作返回以下文档：

{ _id: 3, item: 'ice cream', qty: Long("500"), convertedQty: Long("500") },
{ _id: 2, item: 'pie', qty: '100', convertedQty: Long("100") },
{ _id: 4, item: 'almonds', qty: '50', convertedQty: Long("50") },
{ _id: 1, item: 'apple', qty: 5, convertedQty: Long("5") }