IST转UTC日期时间转换异常：Node.js AWS EC2场景求助

问题背景 #

要将用户输入的IST（印度标准时间）日期时间转换为UTC格式存入数据库，但转换后日期完全不符合预期。Node.js服务器部署在AWS EC2实例上，当前实现逻辑为合并IST日期与时间，再转换为UTC并拆分日期和时间。

错误代码 #

deliveryOrPickUpDate = req.body.deliveryOrPickUpDate;
deliveryOrPickUpTime = req.body.deliveryOrPickUpTime;
console.log(deliveryOrPickUpDate);
console.log(deliveryOrPickUpTime);

let deliveryOrPickUpTimehh = deliveryOrPickUpTime.substring(0,2);
let deliveryOrPickUpTimemm = deliveryOrPickUpTime.substring(3,5);
console.log("deliveryOrPickUpTimehh is :", deliveryOrPickUpTimehh);
console.log("deliveryOrPickUpTimemm is : ", deliveryOrPickUpTimemm);

ISTDateTime = deliveryOrPickUpDate + 'T' + deliveryOrPickUpTimehh + ':' + deliveryOrPickUpTimemm + ':' + '00.000'; //构造T格式字符串，但不带Z标识非UTC时间
console.log("ISTDateTime selected is : ", ISTDateTime);

utcDate = new Date(ISTDateTime); //尝试将IST转换为UTC
console.log(utcDate);

utcDate.setDate(utcDate.getHours() - 5);
utcDate.setDate(utcDate.getMinutes() - 30);

dateISTString = utcDate.toUTCString(); //输出IST格式时间
console.log("India time now is ", dateISTString);

dateUtc =  utcDate.toISOString().slice(0,10);
console.log("Date in UTC is : ", dateUtc);

timeUtc =  utcDate.toISOString().slice(11,19);
console.log("Time in UTC is : ", timeUtc);     

示例控制台输出 #

2023-03-30
22:34:00
deliveryOrPickUpTimehh is : 22
deliveryOrPickUpTimemm is :  34
ISTDateTime selected is :  2023-03-30T22:34:00.000
2023-03-30T17:04:00.000Z
India time now is  Sat, 04 Mar 2023 17:04:00 GMT
Date in UTC is :  2023-03-04
Time in UTC is :  17:04:00

输入的日期和时间：

2023-03-30
22:34:00

错误原因分析 #

1. 方法误用：核心问题是错用setDate()方法——该方法用于设置「一个月中的第几天」，而非调整小时或分钟。原代码中两次用小时、分钟的计算结果调用setDate()，直接导致日期被篡改：第一次用17-5=12把日期设为12号，第二次用4-30=-26，会从当前月份第一天往前推26天，最终得到错误的3月4号。
2. 时区解析模糊：new Date(ISTDateTime)未指定时区，EC2实例默认时区为UTC，因此会把构造的字符串当成UTC时间解析（而非IST）。虽然初始转换后的UTC时间（2023-03-30T17:04:00.000Z）是正确的，但后续错误的日期修改彻底破坏了结果。

修复方案 #

方案1：明确指定时区构造时间字符串 #

直接构造带IST时区偏移（UTC+05:30）的时间字符串，让Date对象正确解析为IST时间，内部自动转换为UTC存储：

const deliveryOrPickUpDate = req.body.deliveryOrPickUpDate;
const deliveryOrPickUpTime = req.body.deliveryOrPickUpTime;

// 构造带IST时区的时间字符串
const istDateTimeStr = `${deliveryOrPickUpDate}T${deliveryOrPickUpTime}+05:30`;
const utcDate = new Date(istDateTimeStr);

// 提取UTC日期和时间
const dateUtc = utcDate.toISOString().slice(0, 10);
const timeUtc = utcDate.toISOString().slice(11, 19);

console.log("Date in UTC is : ", dateUtc);
console.log("Time in UTC is : ", timeUtc);

方案2：手动调整时区（适合明确逻辑场景） #

先解析为IST时间，再减去5小时30分得到UTC时间，注意使用正确的时间调整方法：

const deliveryOrPickUpDate = req.body.deliveryOrPickUpDate;
const deliveryOrPickUpTime = req.body.deliveryOrPickUpTime;

// 解析为IST时间（若服务器时区非IST，优先用方案1）
const istDate = new Date(`${deliveryOrPickUpDate}T${deliveryOrPickUpTime}`);
// 减去IST与UTC的时差（5小时30分）
istDate.setHours(istDate.getHours() - 5);
istDate.setMinutes(istDate.getMinutes() - 30);

// 提取UTC日期和时间
const dateUtc = istDate.toISOString().slice(0, 10);
const timeUtc = istDate.toISOString().slice(11, 19);

console.log("Date in UTC is : ", dateUtc);
console.log("Time in UTC is : ", timeUtc);

修复后结果 #

输入2023-03-30 22:34:00，将得到正确的UTC日期2023-03-30，时间17:04:00，符合预期。

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