トップ > Google Apps Script > Google Apps Scriptの日付文字列の変換

Google Apps Scriptの日付文字列の変換

Google Apps Script

Dateオブジェクト (日付と時刻) | JavaScript プログラミング解説
こちらを参考にGoogle Apps Scriptの日付文字列の変換の一覧表を作ってみました。

function testdate(){
  var today = new Date();
  var date_patterns = ['2008年5月1日 2:00:00','2008/5/1 2:00:00','2008/05/01 02:00:00','2008/05/0102:00:00','2008-5-1 2:00:00','2008-05-01T02:00:00+09:00','2008-05-01T02:00:00+0900','2008-04-30T17:00:00.000Z','2008/5/1T2:00:00+0900','2008/5/1 2:00:00+0900','2008/5/1 2:00:00 +0900','Thu, 1 May 08 02:00:00 +0900','Thu, 1 May 2008 02:00:00 +0900','Thu May 1 02:00:00 +0900 2008','Thu May 1 02:00:00 UTC+0900 2008','Thu May 01 2008 02:00:00 GMT+0900','Thu May 01 2008 02:00:00 GMT+0900','Thursday, 01-May-08 02:00:00 JST','Wednesday, 30-Apr-08 17:00:00 GMT'];
  
  for(i in date_patterns){

    Logger.log(date_patterns[i]);

    var date = new Date(date_patterns[i]);

    Logger.log(date);
  }
}

規格 文字列 GAS
  '2008年5月1日 2:00:00' ×
  '2008/5/1 2:00:00' ○
  '2008/05/01 02:00:00' ○
  '2008/05/0102:00:00' ×
  '2008-5-1 2:00:00' ×
W3C '2008-05-01T02:00:00+09:00' ×
ISO-8601 '2008-05-01T02:00:00+0900' ×
ISO-8601
拡張フォーマット		 '2008-04-30T17:00:00.000Z' ○
  '2008/5/1T2:00:00+0900' ×
  '2008/5/1 2:00:00+0900' ×
  '2008/5/1 2:00:00 +0900' ○
RFC 822
RFC 1036		 'Thu, 1 May 08 02:00:00 +0900' ×
RFC 1123
RFC 2822		 'Thu, 1 May 2008 02:00:00 +0900' ○
  'Thu May 1 02:00:00 +0900 2008' ○
  'Thu May 1 02:00:00 UTC+0900 2008' ○
  'Thu May 01 2008 02:00:00 GMT+0900' ○
  'Thu May 01 2008 02:00:00 GMT+0900'
(Japan Standard Time)		 ○
RFC 850 'Thursday, 01-May-08 02:00:00 JST' ×
'Wednesday, 30-Apr-08 17:00:00 GMT' ×

SimpleDateFormat (Java Platform SE 7 )