convert timestamp to one array-CodePudding

Running in App script, google sheet. I get the timestamp from API and return this result:

[[1.6370611672429312E18], [1.63706107263277082E18]],

I do this code and work fine, but the problem is not in the array, I need it every time in an array:

 const timestamps = [[1.6370611672429312E18], [1.63706107263277082E18]];
for (let i = 0; i < timestamps.length; i  ) {
  const timestamp = new Date(timestamps[i][0] / 1000000);
  const convertDate = Utilities.formatDate(timestamp, "GMT", "MM-dd-yyyy HH:mm:ss");
}

the result is:

1:52:34 PM  Info    11-16-2021 12:52:33
1:52:34 PM  Info    11-16-2021 12:52:33
1:52:34 PM  Info    11-16-2021 12:52:33

I need results like that: 1:52:34 PM Info [[11-16-2021 12:52:33], [11-16-2021 12:50:10]]

to put in sheet by this code: sheet.getRange(1,1,convertDate .length, convertDate [0].length).setValues(convertDate );

CodePudding user response：

const timestamps = [[1.6370611672429312E18], [1.63706107263277082E18]];
const toISOStringWithTimezone = date => {
  const pad = n => `${Math.floor(Math.abs(n))}`.padStart(2, '0');
  return date.getFullYear()  
    '-'   pad(date.getMonth()   1)  
    '-'   pad(date.getDate())  
    ' '   pad(date.getHours())  
    ':'   pad(date.getMinutes())  
    ':'   pad(date.getSeconds())
};
const hasArrDate = (data = []) => {
  return data.flat().map(v => toISOStringWithTimezone(new Date(v / 1000000)))
}
console.log(hasArrDate(timestamps));

CodePudding user response：

const timestamps = [[1.6370611672429312E18], [1.63706107263277082E18]];
let convertedDates = []; // Create an array to store the converted dates
for (let i = 0; i < timestamps.length; i  ) {
  const timestamp = new Date(timestamps[i][0] / 1000000);
  const convertedDate = Utilities.formatDate(timestamp, "GMT", "MM-dd-yyyy HH:mm:ss");
  convertedDates.push([convertedDate]); // Wrap each in [] because this will be printed as a single column
}

const sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName(SHEET_NAME);
sheet.getRange(1, 1, convertedDates.length, convertedDates[0].length).setValues(convertedDates);