Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions,
see Getting Started with Amazon Web Services in China
(PDF).
$toLong
New from version 4.0
The $toLong operator in Amazon DocumentDB is used to convert a value to a 64-bit integer (long) data type. This can be useful when you need to perform arithmetic operations or comparisons on numeric values that may be stored as strings or other data types.
Parameters
Example (MongoDB Shell)
This example demonstrates how to use the $toLong operator to convert a string value to a 64-bit integer.
Create sample documents
db.numbers.insertMany([
{ _id: 1, value: "42" },
{ _id: 3, value: "9223372036854775807" }
]);
Query example
db.numbers.aggregate([
{
$project: {
_id: 1,
longValue: { $toLong: "$value" }
}
}
])
Output
[
{ "_id" : 1, "longValue" : 42 },
{ "_id" : 3, "longValue" : 9223372036854775807 }
]
Code examples
To view a code example for using the $toLong command, choose the tab for the language that you want to use:
- Node.js
-
const { MongoClient } = require('mongodb');
async function example() {
const client = await MongoClient.connect('mongodb://<username>:<password>@<cluster-endpoint>:27017/?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false');
const db = client.db('test');
const numbers = db.collection('numbers');
const result = await numbers.aggregate([
{
$project: {
_id: 1,
longValue: { $toLong: "$value" }
}
}
]).toArray();
console.log(result);
await client.close();
}
example();
- Python
-
from pymongo import MongoClient
def example():
client = MongoClient('mongodb://<username>:<password>@<cluster-endpoint>:27017/?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false')
db = client.test
numbers = db.numbers
result = list(numbers.aggregate([
{
'$project': {
'_id': 1,
'longValue': { '$toLong': '$value' }
}
}
]))
print(result)
client.close()
example()