将日期与mongodb ISO日期进行比较

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

async function findEventsAfterSpecificDate(date) {
  const uri = "your_mongodb_connection_string";
  const client = new MongoClient(uri);

  try {
    await client.connect();
    const database = client.db('your_database_name');
    const collection = database.collection('events');

    // 将JavaScript Date对象转换为ISODate
    const isoDate = new Date(date);

    // 查询所有eventDate大于指定日期的文档
    const query = { eventDate: { $gt: isoDate } };
    const events = await collection.find(query).toArray();

    return events;
  } finally {
    await client.close();
  }
}

// 使用示例
findEventsAfterSpecificDate('2023-01-01').then(console.log);

// 错误的日期格式
const wrongDate = new Date('2023-01-01'); // 可能会解析为本地时区的午夜

// 正确的日期格式，指定UTC时区
const correctDate = new Date('2023-01-01T00:00:00Z');

// 使用ISO 8601格式的字符串
const isoDateString = '2023-01-01T00:00:00Z';
const date = new Date(isoDateString);