$toDouble(aggregation)¶

Definition定义¶

$toDouble¶

New in version 4.0.版本4.0中的新功能。

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

$toDouble has the following syntax:语法如下所示：

{
   $toDouble: <expression>
}

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

The $toDouble is a shorthand for the following $convert expression:

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

Behavior行为¶

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

The following table lists some conversion to double examples:下表列出了一些转换为双重示例：

Example示例¶

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

db.weather.insert( [
   { _id: 1, date: new Date("2018-06-01"), temp: "26.1C" },
   { _id: 2,  date: new Date("2018-06-02"), temp: "25.1C" },
   { _id: 3,  date: new Date("2018-06-03"), temp: "25.4C" },
] )

The following aggregation operation on the weather collection parses the temp value and converts to a double:weather集合上的以下聚合操作将解析temp值并转换为double：

// Define stage to add degrees field with converted value

tempConversionStage = {
   $addFields: {
      degrees: { $toDouble: { $substrBytes: [ "$temp", 0, 4 ] } }
   }
};


db.weather.aggregate( [
   tempConversionStage,
])

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

{ "_id" : 1, "date" : ISODate("2018-06-01T00:00:00Z"), "temp" : "26.1C", "degrees" : 26.1 }
{ "_id" : 2, "date" : ISODate("2018-06-02T00:00:00Z"), "temp" : "25.1C", "degrees" : 25.1 }
{ "_id" : 3, "date" : ISODate("2018-06-03T00:00:00Z"), "temp" : "25.4C", "degrees" : 25.4 }