On this page本页内容
$toString
New in version 4.0.在版本4.0中新增。
Converts a value to a string. If the value cannot be converted to a string, 将值转换为字符串。如果值无法转换为字符串,则$toString
errors. $toString
会出错。If the value is null or missing, 如果值为$toString
returns null.null
或缺失,$toString
将返回null
。
$toString
has the following syntax:语法如下:
{
$toString: <expression>
}
The $toString
takes any valid expression.$toString
接受任何有效表达式。
The $toString
is a shorthand for the following $convert
expression:$toString
是以下$convert
表达式的缩写:
{ $convert: { input: <expression>, to: "string" } }
The following table lists the input types that can be converted to a string:下表列出了可以转换为字符串的输入类型:
Boolean | |
Double | |
Decimal | |
Integer | |
Long | |
ObjectId | |
String | |
Date |
The following table lists some conversion to string examples:下表列出了一些转换为字符串的示例:
{$toString: true} | "true" |
{$toString: false} | "false" |
{$toString: 2.5} | "2.5" |
{$toString: NumberInt(2)} | "2" |
{$toString: NumberLong(1000)} | "1000" |
{$toString: ObjectId("5ab9c3da31c2ab715d421285")} | "5ab9c3da31c2ab715d421285" |
{$toString: ISODate("2018-03-27T16:58:51.538Z")} | "2018-03-27T16:58:51.538Z" |
Create a collection 使用以下文档创建集合orders
with the following documents:orders
:
db.orders.insertMany( [ { _id: 1, item: "apple", qty: 5, zipcode: 93445 }, { _id: 2, item: "almonds", qty: 2, zipcode: "12345-0030" }, { _id: 3, item: "peaches", qty: 5, zipcode: 12345 }, ] )
The following aggregation operation on the orders
collection converts the zipcode
to string before sorting by the string value:orders
集合上的以下聚合操作在按字符串值排序之前将zipcode
转换为字符串:
// Define stage to add convertedZipCode field with the converted zipcode value zipConversionStage = { $addFields: { convertedZipCode: { $toString: "$zipcode" } } }; // Define stage to sort documents by the converted zipcode sortStage = { $sort: { "convertedZipCode": 1 } }; db.orders.aggregate( [ zipConversionStage, sortStage ] )
The operation returns the following documents:该操作返回以下文档:
{ _id: 3, item: 'peaches', qty: 5, zipcode: 12345, convertedZipCode: '12345' }, { _id: 2, item: 'almonds', qty: 2, zipcode: '12345-0030', convertedZipCode: '12345-0030' }, { _id: 1, item: 'apple', qty: 5, zipcode: 93445, convertedZipCode: '93445' }