本文介绍了Google Apps Script formatDate 使用用户的时区而不是 GMT的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一行设置单元格中的当前日期和时间:

I have a line that sets the current date and time in a cell:

sheet.getRange(1,1).setValue(new Date());

然后我有一行根据该单元格的值创建一个格式化的日期:

Then I have a line that creates a formatted date based on that cell's value:

var addedDate = sheet.getRange(1,1).getValue();
var addedTime = Utilities.formatDate(addedDate, "GMT", "hh:mm a");

结果 addedTime 似乎在 GMT 时区,我需要它在用户的时区.它通常是美国东部时间 (-0500),但如果我只是从时间中减去 5 小时,那么这并没有考虑到夏令时 (-0400).

The resulting addedTime seems to be in the GMT time zone and I need it to be in the user's time zone. It will usually be US Eastern Time (-0500), but if I simply subtract 5 hours from the time then that doesn't account for daylight saving time (-0400).

我在这里查看了 formatDate 的文档:https://developers.google.com/apps-script/reference/utilities/utilities#formatDate(Date,String,String)

I checked the documentation for formatDate here: https://developers.google.com/apps-script/reference/utilities/utilities#formatDate(Date,String,String)

此处链接到官方 Java SimpleDateFormat 类文档:http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html

which links to the official Java SimpleDateFormat class documentation here: http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html

...但我找不到可用的有效时区列表来替换 GMT.

... but I can't find a list of valid time zones there to replace the GMT with.

推荐答案

可以像这样直接得到电子表格Time Zone:

You can directly get the spreadsheet Time Zone like this :

  var addedDate = sheet.getRange(1,1).getValue();
  var addedTime = Utilities.formatDate(addedDate, SpreadsheetApp.getActive().getSpreadsheetTimeZone(), "hh:mm a");

请参阅此处的文档

但如果您想自己选择,Google Apps Script 会使用这些格式:

but Google Apps Script uses these formats if you want to choose it yourself :

http://joda-time.sourceforge.net/timezones.html

这篇关于Google Apps Script formatDate 使用用户的时区而不是 GMT的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-05 05:05