我有來自 API 呼叫的以下時間戳：
2022-05-22T13:53:42.010238Z
2022-05-22T11:53:30.910039Z
2022-05-22T11:46:43.904101Z
2022-05-22T11:46:27.815341Z
2022-05-22T11:46:12.581602Z
2022-05-22T11:41:56.246782Z
2022-05-22T11:41:39.443423Z
我想將它們轉換為可讀的日期，例如：22/05/2022-13:53:42并為它們添加 3 小時。
uj5u.com熱心網友回復：
你可以試試下面的公式——
=SUM(SPLIT(SUBSTITUTE(A1,"Z",""),"T")) TIME(3,0,0)
uj5u.com熱心網友回復：
在您的情況下，以下示例腳本怎么樣？
示例腳本：
function myFunction() {
const data = [
"2022-05-22T13:53:42.010238Z",
"2022-05-22T11:53:30.910039Z",
"2022-05-22T11:46:43.904101Z",
"2022-05-22T11:46:27.815341Z",
"2022-05-22T11:46:12.581602Z",
"2022-05-22T11:41:56.246782Z",
"2022-05-22T11:41:39.443423Z",
];
const add = 3 * 60 * 60 * 1000;
const res = data.map(e => Utilities.formatDate(new Date(new Date(e).getTime() add), "GMT", "dd/MM/yyyy-HH:mm:ss"));
console.log(res)
}
運行此腳本時，日志中會顯示以下結果。
[ '22/05/2022-16:53:42', '22/05/2022-14:53:30', '22/05/2022-14:46:43', '22/05/2022-14:46:27', '22/05/2022-14:46:12', '22/05/2022-14:41:56', '22/05/2022-14:41:39' ]
參考：
- 地圖（）
- formatDate（日期，時區，格式）
uj5u.com熱心網友回復：
轉換時間戳并增加 3 小時
function lfunko() {
const dA = [
"2022-05-22T13:53:42.010238Z", "2022-05-22T11:53:30.910039Z", "2022-05-22T11:46:43.904101Z", "2022-05-22T11:46:27.815341Z", "2022-05-22T11:46:12.581602Z", "2022-05-22T11:41:56.246782Z", "2022-05-22T11:41:39.443423Z"];
dtA = dA.reduce((a, c, i) => {
let dt = new Date(c);
dt.setHours(new Date(c).getHours() 3);
a.dts.push(dt);
return a;
}, { dts: [] }).dts;
Logger.log(JSON.stringify(dtA))
}
Execution log
10:06:46 PM Notice Execution started
10:06:45 PM Info ["2022-05-22T16:53:42.010Z","2022-05-22T14:53:30.910Z","2022-05-22T14:46:43.904Z","2022-05-22T14:46:27.815Z","2022-05-22T14:46:12.581Z","2022-05-22T14:41:56.246Z","2022-05-22T14:41:39.443Z"]
10:06:47 PM Notice Execution completed
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/481058.html