使用NODEJS -LAMBDA将EPOCH时间转换为MYSQL TIMESTAMP

Question

var epochtime = "1610950344";
var datevar = new Date(epochtime *1000);
var mytime = datevar.toISOString().slice(0, 19).replace('T', ' ');
console.log("DATEEEEEEEEEE : "+mytime);

const query = `INSERT INTO MYTIME (MY_TIME, NAME) VALUES ('${mytime}', 'ANN')`;  
updateDB(query); //Custom function to create a connection and insert the data into the table

MY_TIME在mysql模式中被定义为TIMESTAMP。上面的查询除MY_TIME字段外正常工作。当插入mytime时，它将值更改为"0000-00-00 00:00:00";在mysql。为什么会发生这种情况?数据转换有什么问题吗?请帮助

Answer 1

您可以简单地像这样查询:

INSERT INTO MYTIME (MY_TIME, NAME) VALUES (FROM_UNIXTIME(${epochtime}), 'ANN')