如何获取BSON UTC datetime值？解决MongoDB时间序列数据库文档插入报错问题

Hey there! I totally get how frustrating this error can be—MongoDB's time series collections are pretty strict about the time field being a proper BSON UTC datetime, not just any string or timestamp format. Let's fix this step by step.

The Root of the Problem #

MongoDB requires the time field (in your case created_at) to be a BSON Date object, not a string (even ISO-formatted ones) or numeric timestamp. When you pass a string, MongoDB doesn't recognize it as a valid datetime for the time series collection, hence the error.

Solutions by Environment #

Here's how to generate valid BSON UTC datetime values in the most common tools/languages:

1. Mongo Shell

Use either new Date() (generates current UTC time) or ISODate() (equivalent) to create the BSON Date directly:

// Insert with current UTC time
db.your_time_series_coll.insertOne({
  created_at: new Date(),
  temperature: 22.3,
  location: "office"
})

// Insert with a specific UTC time (note the 'Z' to indicate UTC)
db.your_time_series_coll.insertOne({
  created_at: new Date("2024-05-20T14:45:00Z"),
  temperature: 24.1,
  location: "warehouse"
})

2. Python (with PyMongo)

Use Python's datetime module to create a UTC-aware datetime object—PyMongo will automatically convert this to a BSON Date:

from pymongo import MongoClient
import datetime

client = MongoClient("mongodb://localhost:27017")
db = client.your_database
coll = db.your_time_series_coll

# Option 1: Current UTC time
current_utc = datetime.datetime.now(datetime.timezone.utc)

# Option 2: Specific UTC time
specific_utc = datetime.datetime.fromisoformat("2024-05-20T14:45:00+00:00")

# Insert the document
coll.insert_one({
  "created_at": current_utc,
  "temperature": 22.3,
  "location": "office"
})

Pro tip: Always use timezone-aware datetime objects (like datetime.timezone.utc) to avoid local time conversion issues.

3. Node.js (with MongoDB Driver)

In Node.js, new Date() creates a UTC-based Date object that MongoDB recognizes as BSON Date. You can also pass an ISO string with 'Z' to create a specific time:

const { MongoClient } = require('mongodb');

async function insertTimeSeriesDoc() {
  const client = new MongoClient("mongodb://localhost:27017");
  await client.connect();
  
  const db = client.db("your_database");
  const coll = db.collection("your_time_series_coll");

  // Current UTC time
  const currentUtc = new Date();

  // Specific UTC time
  const specificUtc = new Date("2024-05-20T14:45:00Z");

  await coll.insertOne({
    created_at: currentUtc,
    temperature: 24.1,
    location: "warehouse"
  });

  await client.close();
}

insertTimeSeriesDoc();

Common Mistake to Avoid #

Don't pass time values as strings (even if they look like ISO dates, e.g., "2024-05-20T14:45:00Z"). MongoDB will store these as plain strings, not BSON Date objects, which triggers the error you're seeing. Always use your language's native Date/datetime type.

内容的提问来源于stack exchange，提问作者Piyush