javascript - 计算 Google Apps 脚本中两个日期之间的差异

Question

我正在从 API 调用中获取日期时间，如下所示:

2017-11-21T20:23:26+0000

现在我想将它与今天的日期进行比较并计算天数差异，我该如何在 google apps 脚本中执行此操作。

谢谢你的帮助。

Answer 1

这是采用不同方法的天数、分钟数和小时数:

function getDaysHoursAndMinutes(){
  var hd=new Date('2017-11-21T20:23:26+0000').valueOf();
  var td=new Date().valueOf();
  var sec=1000;
  var min=60*sec;
  var hour=60*min;
  var day=24*hour;
  var diff=td-hd;
  var days=Math.floor(diff/day);
  var hours=Math.floor(diff%day/hour);
  var minutes=Math.floor(diff%day%hour/min);
  Logger.log('%s days %s hours %s minutes',days,hours,minutes);
}

The basic idea is that the value of a date is the number of milliseconds from a given date time reference which I think in this case is January 1, 1970.