converttolocaltime - 指令碼與圖表函數

UTCGMT 時間戳記轉換為當地時間作為雙值。其中 place 可為全世界任何一個城市、地點及時區。 

Syntax:  

ConvertToLocalTime(timestamp [, place [, ignore_dst=false]])

Return data type: 雙值

Arguments:  

引數 描述
timestamp 要轉換的時間戳記或解析為時間戳記的運算式。
place

下方有效地點及時區表格中的地點或時區。或者,您可以使用 GMTUTC 來定義當地時間。下列值及時間偏移範圍有效:

  • GMT
  • GMT-12:00 - GMT-01:00
  • GMT+01:00 - GMT+14:00
  • UTC
  • UTC-12:00 - UTC-01:00
  • UTC+01:00 - UTC+14:00
備註: 您只能使用標準時間偏移。不能使用任意的時間偏移,例如,GMT-04:27
ignore_dst 如果您想要忽略 DST (日光節約時間),設為 True

產生的時間會根據日光節約時間進行調整,除非 ignore_dst 設為 True

有效的地點和時區
Abu Dhabi Central America Kabul Newfoundland Tashkent
Adelaide Central Time (US & Canada) Kamchatka Novosibirsk Tbilisi
Alaska Chennai Karachi Nuku'alofa Tehran
Amsterdam Chihuahua Kathmandu Osaka Tokyo
Arizona Chongqing Kolkata Pacific Time (US & Canada) Urumqi
Astana Copenhagen Krasnoyarsk Paris Warsaw
Athens Darwin Kuala Lumpur Perth Wellington
Atlantic Time (Canada) Dhaka Kuwait Port Moresby West Central Africa
Auckland Eastern Time (US & Canada) Kyiv Prague Vienna
Azores Edinburgh La Paz Pretoria Vilnius
Baghdad Ekaterinburg Lima Quito Vladivostok
Baku Fiji Lisbon Riga Volgograd
Bangkok Georgetown Ljubljana Riyadh Yakutsk
Beijing Greenland London Rome Yerevan
Belgrade Greenwich Mean Time : Dublin Madrid Samoa Zagreb
Berlin Guadalajara Magadan Santiago  
Bern Guam Mazatlan Sapporo  
Bogota Hanoi Melbourne Sarajevo  
Brasilia Harare Mexico City Saskatchewan  
Bratislava Hawaii Mid-Atlantic Seoul  
Brisbane Helsinki Minsk Singapore  
Brussels Hobart Monrovia Skopje  
Bucharest Hong Kong Monterrey Sofia  
Budapest Indiana (East) Moscow Solomon Is.  
Buenos Aires International Date Line West Mountain Time (US & Canada) Sri Jayawardenepura  
Cairo Irkutsk Mumbai St. Petersburg  
Canberra Islamabad Muscat Stockholm  
Cape Verde Is. Istanbul Nairobi Sydney  
Caracas Jakarta New Caledonia Taipei  
Casablanca Jerusalem New Delhi Tallinn