Firebase函数日期转换问题：如何强制生成指定时间范围的Firestore Timestamp

问题核心在于Firestore存储的Timestamp是UTC时区，而你的代码之前基于本地时区构造时间范围，导致查询时出现偏移，统计不准确。以下是两种可靠的解决方法：

方法1：使用UTC时间构造Date对象 #

直接基于UTC时区生成目标日期的00:00到次日00:00范围（推荐用次日00:00作为结束时间，避免毫秒级遗漏）：

修改generateDailyStats函数：

async function generateDailyStats(date) {
    let startDate;
    let endDate;

    // 定时任务获取昨日统计
    if (date === undefined) {
        const nowUTC = new Date(Date.UTC());
        // 昨日UTC 00:00
        startDate = new Date(Date.UTC(nowUTC.getUTCFullYear(), nowUTC.getUTCMonth(), nowUTC.getUTCDate() - 1));
        // 今日UTC 00:00（作为结束边界）
        endDate = new Date(Date.UTC(nowUTC.getUTCFullYear(), nowUTC.getUTCMonth(), nowUTC.getUTCDate()));
    } else { // 手动指定日期统计
        const targetDate = new Date(date);
        // 指定日期的UTC 00:00
        startDate = new Date(Date.UTC(targetDate.getUTCFullYear(), targetDate.getUTCMonth(), targetDate.getUTCDate()));
        // 指定日期次日的UTC 00:00（作为结束边界）
        endDate = new Date(Date.UTC(targetDate.getUTCFullYear(), targetDate.getUTCMonth(), targetDate.getUTCDate() + 1));
    }

    console.log(startDate); // 2023-01-30T00:00:00.000Z
    console.log(endDate);   // 2023-01-31T00:00:00.000Z

    const usersCreatedYesterday = await getCountOfCollectionItemsCreatedForDates('users', 'createdAt', startDate, endDate);

    const stats = {
        date: startDate,
        usersCreated: usersCreatedYesterday
    };

    await saveDailyUsageToFirebase(stats, startDate.toISOString().slice(0, 10));

    return stats;
}

方法2：直接使用Firestore Timestamp类 #

借助Firebase Admin SDK的Timestamp类构造时间范围，完全对齐Firestore的存储格式：

首先引入Timestamp：

const { Timestamp } = require('firebase-admin/firestore');

然后修改generateDailyStats函数：

async function generateDailyStats(date) {
    let startTimestamp;
    let endTimestamp;

    // 定时任务获取昨日统计
    if (date === undefined) {
        const nowUTC = new Date(Date.UTC());
        const yesterdayUTC = new Date(Date.UTC(nowUTC.getUTCFullYear(), nowUTC.getUTCMonth(), nowUTC.getUTCDate() - 1));
        startTimestamp = Timestamp.fromDate(yesterdayUTC);
        const todayUTC = new Date(Date.UTC(nowUTC.getUTCFullYear(), nowUTC.getUTCMonth(), nowUTC.getUTCDate()));
        endTimestamp = Timestamp.fromDate(todayUTC);
    } else { // 手动指定日期统计
        const targetDate = new Date(date);
        const startDateUTC = new Date(Date.UTC(targetDate.getUTCFullYear(), targetDate.getUTCMonth(), targetDate.getUTCDate()));
        startTimestamp = Timestamp.fromDate(startDateUTC);
        const nextDayUTC = new Date(Date.UTC(targetDate.getUTCFullYear(), targetDate.getUTCMonth(), targetDate.getUTCDate() + 1));
        endTimestamp = Timestamp.fromDate(nextDayUTC);
    }

    console.log(startTimestamp.toDate()); // 2023-01-30T00:00:00.000Z
    console.log(endTimestamp.toDate());   // 2023-01-31T00:00:00.000Z

    const usersCreatedYesterday = await getCountOfCollectionItemsCreatedForDates('users', 'createdAt', startTimestamp, endTimestamp);

    const stats = {
        date: startTimestamp.toDate(),
        usersCreated: usersCreatedYesterday
    };

    await saveDailyUsageToFirebase(stats, startTimestamp.toDate().toISOString().slice(0, 10));

    return stats;
}

关键说明 #

1. 为什么用次日00:00作为结束时间？
   Firestore的Timestamp精度可达纳秒，用23:59:59.999作为结束边界可能会漏掉部分时间戳大于该值的文档，改用次日00:00并配合<条件，能100%覆盖目标日期的所有文档。
2. 时区对齐逻辑：
   所有时间范围都基于UTC时区构造，和Firestore存储的Timestamp时区完全一致，彻底解决本地时区偏移导致的统计误差。

内容的提问来源于stack exchange，提问作者Theuno de Bruin