Timezone specifiers
Below is a list of timezone specifiers you may use for any date/datetime formulas.
Time Zone Value | Standard Time (UTC) | Daylight Savings Time (UTC) | Included States and Territories | Notes | |
Atlantic | America/Puerto_Rico | UTC-04:00 | n/a | Puerto Rico, US Virgin Islands | Daylight Savings Time is not observed. |
Eastern | US/Eastern | UTC-05:00 | UTC-04:00 | Entire: Connecticut, Delaware, Georgia, Maine, Maryland, Massachusetts, New Hampshire, New Jersey, New York, North Carolina, Ohio, Pennsylvania, Rhode Island, South Carolina, Vermont, Virginia, West Virginia Partial: Florida, Indiana, Kentucky, Michigan, Tennessee | |
Central | US/Central | UTC-06:00 | UTC-05:00 | Entire: Alabama, Arkansas, Illinois, Iowa, Louisiana, Minnesota, Mississippi, Missouri, Oklahoma, Wisconsin Partial: Florida, Indiana, Kansas, Kentucky, Michigan, Nebraska, North Dakota, South Dakota, Tennessee, Texas | |
Mountain | US/Mountain | UTC-07:00 | UTC-06:00 | Entire: Arizona, Colorado, Montana, New Mexico, Utah, Wyoming Partial: Idaho, Kansas, Nebraska, Nevada, North Dakota, Oregon, South Dakota, Texas | Most of Arizona does not observe Daylight Savings Time. Use US/Arizona in this area. |
Pacific | US/Pacific | UTC-08:00 | UTC-07:00 | Entire: California, Washington Partial: Idaho, Nevada, Oregon | |
Alaska | US/Alaska | UTC-09:00 | UTC-08:00 | Partial: Alaska | Daylight Savings Time is not observed in the Aleutian Islands. Use US/Aleutian in this area. |
Hawaii | US/Hawaii | UTC-10:00 | UTC-09:00 | Entire: Hawaii Partial: Alaska | Daylight Savings Time is not observed in Hawaii. |
For the functions that support use of specified time zones, you can apply the following string values as parameters to specify the time zone:
Time Zone Value | Standard time (UTC) | Daylight Saving time (UTC) | Partial country coverage |
Time Zone Value | Standard time (UTC) | Daylight Saving time (UTC) | Partial country coverage |
Africa/Abidjan | UTC+00:00 | UTC+00:00 | |
Africa/Accra | UTC+00:00 | UTC+00:00 | |
Africa/Addis_Ababa | UTC+03:00 | UTC+03:00 | |
Africa/Algiers | UTC+01:00 | UTC+01:00 | |
Africa/Asmara | UTC+03:00 | UTC+03:00 | |
Africa/Bamako | UTC+00:00 | UTC+00:00 | |
Africa/Bangui | UTC+01:00 | UTC+01:00 | |
Africa/Banjul | UTC+00:00 | UTC+00:00 | |
Africa/Bissau | UTC+00:00 | UTC+00:00 | |
Africa/Blantyre | UTC+02:00 | UTC+02:00 | |
Africa/Brazzaville | UTC+01:00 | UTC+01:00 | |
Africa/Bujumbura | UTC+02:00 | UTC+02:00 | |
Africa/Cairo | UTC+02:00 | UTC+02:00 | |
Africa/Casablanca | UTC+01:00 | UTC+01:00 | |
Africa/Ceuta | UTC+01:00 | UTC+01:00 | Ceuta, Melilla |
Africa/Conakry | UTC+00:00 | UTC+00:00 | |
Africa/Dakar | UTC+00:00 | UTC+00:00 | |
Africa/Dar_es_Salaam | UTC+03:00 | UTC+03:00 | |
Africa/Djibouti | UTC+03:00 | UTC+03:00 | |
Africa/Douala | UTC+01:00 | UTC+01:00 | |
Africa/El_Aaiun | UTC+00:00 | UTC+01:00 | |
Africa/Freetown | UTC+00:00 | UTC+00:00 | |
Africa/Gaborone | UTC+02:00 | UTC+02:00 | |
Africa/Harare | UTC+02:00 | UTC+02:00 | |
Africa/Johannesburg | UTC+02:00 | UTC+02:00 | |
Africa/Juba | UTC+03:00 | UTC+03:00 | |
Africa/Kampala | UTC+03:00 | UTC+03:00 | |
Africa/Khartoum | UTC+02:00 | UTC+02:00 | |
Africa/Kigali | UTC+02:00 | UTC+02:00 | |
Africa/Kinshasa | UTC+01:00 | UTC+01:00 | Dem. Rep. of Congo (west) |
Africa/Lagos | UTC+01:00 | UTC+01:00 | |
Africa/Libreville | UTC+01:00 | UTC+01:00 | |
Africa/Lome | UTC+00:00 | UTC+00:00 | |
Africa/Luanda | UTC+01:00 | UTC+01:00 | |
Africa/Lubumbashi | UTC+02:00 | UTC+02:00 | Dem. Rep. of Congo (east) |
Africa/Lusaka | UTC+02:00 | UTC+02:00 | |
Africa/Malabo | UTC+01:00 | UTC+01:00 | |
Africa/Maputo | UTC+02:00 | UTC+02:00 | |
Africa/Maseru | UTC+02:00 | UTC+02:00 | |
Africa/Mbabane | UTC+02:00 | UTC+02:00 | |
Africa/Mogadishu | UTC+03:00 | UTC+03:00 | |
Africa/Monrovia | UTC+00:00 | UTC+00:00 | |
Africa/Nairobi | UTC+03:00 | UTC+03:00 | |
Africa/Ndjamena | UTC+01:00 | UTC+01:00 | |
Africa/Niamey | UTC+01:00 | UTC+01:00 | |
Africa/Nouakchott | UTC+00:00 | UTC+00:00 | |
Africa/Ouagadougou | UTC+00:00 | UTC+00:00 | |
Africa/Porto-Novo | UTC+01:00 | UTC+01:00 | |
Africa/Sao_Tome | UTC+00:00 | UTC+00:00 | |
Africa/Timbuktu | UTC+00:00 | UTC+00:00 | |
Africa/Tripoli | UTC+02:00 | UTC+02:00 | |
Africa/Tunis | UTC+01:00 | UTC+01:00 | |
Africa/Windhoek | UTC+02:00 | UTC+02:00 | |
America/Adak | UTC−10:00 | UTC−09:00 | Aleutian Islands |
America/Anchorage | UTC−09:00 | UTC−08:00 | Alaska (most areas) |
America/Anguilla | UTC−04:00 | UTC−04:00 | |
America/Antigua | UTC−04:00 | UTC−04:00 | |
America/Araguaina | UTC−03:00 | UTC−03:00 | Tocantins |
America/Argentina/Buenos_Aires | UTC−03:00 | UTC−03:00 | Buenos Aires (BA, CF) |
America/Argentina/Catamarca | UTC−03:00 | UTC−03:00 | Catamarca (CT); Chubut (CH) |
America/Argentina/ComodRivadavia | UTC−03:00 | UTC−03:00 | |
America/Argentina/Cordoba | UTC−03:00 | UTC−03:00 | Argentina (most areas: CB, CC, CN, ER, FM, MN, SE, SF) |
America/Argentina/Jujuy | UTC−03:00 | UTC−03:00 | Jujuy (JY) |
America/Argentina/La_Rioja | UTC−03:00 | UTC−03:00 | La Rioja (LR) |
America/Argentina/Mendoza | UTC−03:00 | UTC−03:00 | Mendoza (MZ) |
America/Argentina/Rio_Gallegos | UTC−03:00 | UTC−03:00 | Santa Cruz (SC) |
America/Argentina/Salta | UTC−03:00 | UTC−03:00 | Salta (SA, LP, NQ, RN) |
America/Argentina/San_Juan | UTC−03:00 | UTC−03:00 | San Juan (SJ) |
America/Argentina/San_Luis | UTC−03:00 | UTC−03:00 | San Luis (SL) |
America/Argentina/Tucuman | UTC−03:00 | UTC−03:00 | Tucuman (TM) |
America/Argentina/Ushuaia | UTC−03:00 | UTC−03:00 | Tierra del Fuego (TF) |
America/Aruba | UTC−04:00 | UTC−04:00 | |
America/Asuncion | UTC−04:00 | UTC−03:00 | |
America/Atikokan | UTC−05:00 | UTC−05:00 | EST - ON (Atikokan); NU (Coral H) |
America/Atka | UTC−10:00 | UTC−09:00 | |
America/Bahia | UTC−03:00 | UTC−03:00 | Bahia |
America/Bahia_Banderas | UTC−06:00 | UTC−05:00 | Central Time - Bahia de Banderas |
America/Barbados | UTC−04:00 | UTC−04:00 | |
America/Belem | UTC−03:00 | UTC−03:00 | Para (east); Amapa |
America/Belize | UTC−06:00 | UTC−06:00 | |
America/Blanc-Sablon | UTC−04:00 | UTC−04:00 | AST - QC (Lower North Shore) |
America/Boa_Vista | UTC−04:00 | UTC−04:00 | Roraima |
America/Bogota | UTC−05:00 | UTC−05:00 | |
America/Boise | UTC−07:00 | UTC−06:00 | Mountain - ID (south); OR (east) |
America/Buenos_Aires | UTC−03:00 | UTC−03:00 | |
America/Cambridge_Bay | UTC−07:00 | UTC−06:00 | Mountain - NU (west) |
America/Campo_Grande | UTC−04:00 | UTC−03:00 | Mato Grosso do Sul |
America/Cancun | UTC−05:00 | UTC−05:00 | Eastern Standard Time - Quintana Roo |
America/Caracas | UTC−04:00 | UTC−04:00 | |
America/Catamarca | UTC−03:00 | UTC−03:00 | |
America/Cayenne | UTC−03:00 | UTC−03:00 | |
America/Cayman | UTC−05:00 | UTC−05:00 | |
America/Chicago | UTC−06:00 | UTC−05:00 | Central (most areas) |
America/Chihuahua | UTC−07:00 | UTC−06:00 | Mountain Time - Chihuahua (most areas) |
America/Coral_Harbour | UTC−05:00 | UTC−05:00 | |
America/Cordoba | UTC−03:00 | UTC−03:00 | |
America/Costa_Rica | UTC−06:00 | UTC−06:00 | |
America/Creston | UTC−07:00 | UTC−07:00 | MST - BC (Creston) |
America/Cuiaba | UTC−04:00 | UTC−03:00 | Mato Grosso |
America/Curacao | UTC−04:00 | UTC−04:00 | |
America/Danmarkshavn | UTC+00:00 | UTC+00:00 | National Park (east coast) |
America/Dawson | UTC−08:00 | UTC−07:00 | Pacific - Yukon (north) |
America/Dawson_Creek | UTC−07:00 | UTC−07:00 | MST - BC (Dawson Cr, Ft St John) |
America/Denver | UTC−07:00 | UTC−06:00 | Mountain (most areas) |
America/Detroit | UTC−05:00 | UTC−04:00 | Eastern - MI (most areas) |
America/Dominica | UTC−04:00 | UTC−04:00 | |
America/Edmonton | UTC−07:00 | UTC−06:00 | Mountain - AB; BC (E); SK (W) |
America/Eirunepe | UTC−05:00 | UTC−05:00 | Amazonas (west) |
America/El_Salvador | UTC−06:00 | UTC−06:00 | |
America/Ensenada | UTC−08:00 | UTC−07:00 | |
America/Fort_Nelson | UTC−07:00 | UTC−07:00 | MST - BC (Ft Nelson) |
America/Fort_Wayne | UTC−05:00 | UTC−04:00 | |
America/Fortaleza | UTC−03:00 | UTC−03:00 | Brazil (northeast: MA, PI, CE, RN, PB) |
America/Glace_Bay | UTC−04:00 | UTC−03:00 | Atlantic - NS (Cape Breton) |
America/Godthab | UTC−03:00 | UTC−02:00 | Greenland (most areas) |
America/Goose_Bay | UTC−04:00 | UTC−03:00 | Atlantic - Labrador (most areas) |
America/Grand_Turk | UTC−05:00 | UTC−04:00 | |
America/Grenada | UTC−04:00 | UTC−04:00 | |
America/Guadeloupe | UTC−04:00 | UTC−04:00 | |
America/Guatemala | UTC−06:00 | UTC−06:00 | |
America/Guayaquil | UTC−05:00 | UTC−05:00 | Ecuador (mainland) |
America/Guyana | UTC−04:00 | UTC−04:00 | |
America/Halifax | UTC−04:00 | UTC−03:00 | Atlantic - NS (most areas); PE |
America/Havana | UTC−05:00 | UTC−04:00 | |
America/Hermosillo | UTC−07:00 | UTC−07:00 | Mountain Standard Time - Sonora |
America/Indiana/Indianapolis | UTC−05:00 | UTC−04:00 | Eastern - IN (most areas) |
America/Indiana/Knox | UTC−06:00 | UTC−05:00 | Central - IN (Starke) |
America/Indiana/Marengo | UTC−05:00 | UTC−04:00 | Eastern - IN (Crawford) |
America/Indiana/Petersburg | UTC−05:00 | UTC−04:00 | Eastern - IN (Pike) |
America/Indiana/Tell_City | UTC−06:00 | UTC−05:00 | Central - IN (Perry) |
America/Indiana/Vevay | UTC−05:00 | UTC−04:00 | Eastern - IN (Switzerland) |
America/Indiana/Vincennes | UTC−05:00 | UTC−04:00 | Eastern - IN (Da, Du, K, Mn) |
America/Indiana/Winamac | UTC−05:00 | UTC−04:00 | Eastern - IN (Pulaski) |
America/Indianapolis | UTC−05:00 | UTC−04:00 | |
America/Inuvik | UTC−07:00 | UTC−06:00 | Mountain - NT (west) |
America/Iqaluit | UTC−05:00 | UTC−04:00 | Eastern - NU (most east areas) |
America/Jamaica | UTC−05:00 | UTC−05:00 | |
America/Jujuy | UTC−03:00 | UTC−03:00 | |
America/Juneau | UTC−09:00 | UTC−08:00 | Alaska - Juneau area |
America/Kentucky/Louisville | UTC−05:00 | UTC−04:00 | Eastern - KY (Louisville area) |
America/Kentucky/Monticello | UTC−05:00 | UTC−04:00 | Eastern - KY (Wayne) |
America/Knox_IN | UTC−06:00 | UTC−05:00 | |
America/Kralendijk | UTC−04:00 | UTC−04:00 | |
America/La_Paz | UTC−04:00 | UTC−04:00 | |
America/Lima | UTC−05:00 | UTC−05:00 | |
America/Los_Angeles | UTC−08:00 | UTC−07:00 | Pacific |
America/Louisville | UTC−05:00 | UTC−04:00 | |
America/Lower_Princes | UTC−04:00 | UTC−04:00 | |
America/Maceio | UTC−03:00 | UTC−03:00 | Alagoas, Sergipe |
America/Managua | UTC−06:00 | UTC−06:00 | |
America/Manaus | UTC−04:00 | UTC−04:00 | Amazonas (east) |
America/Marigot | UTC−04:00 | UTC−04:00 | |
America/Martinique | UTC−04:00 | UTC−04:00 | |
America/Matamoros | UTC−06:00 | UTC−05:00 | Central Time US - Coahuila, Nuevo Leon, Tamaulipas (US border) |
America/Mazatlan | UTC−07:00 | UTC−06:00 | Mountain Time - Baja California Sur, Nayarit, Sinaloa |
America/Mendoza | UTC−03:00 | UTC−03:00 | |
America/Menominee | UTC−06:00 | UTC−05:00 | Central - MI (Wisconsin border) |
America/Merida | UTC−06:00 | UTC−05:00 | Central Time - Campeche, Yucatan |
America/Metlakatla | UTC−09:00 | UTC −08:00 | Alaska - Annette Island |
America/Mexico_City | UTC−06:00 | UTC−05:00 | Central Time |
America/Miquelon | UTC−03:00 | UTC−02:00 | |
America/Moncton | UTC−04:00 | UTC−03:00 | Atlantic - New Brunswick |
America/Monterrey | UTC−06:00 | UTC−05:00 | Central Time - Durango; Coahuila, Nuevo Leon, Tamaulipas (most areas) |
America/Montevideo | UTC−03:00 | UTC−03:00 | |
America/Montreal | UTC−05:00 | UTC−04:00 | |
America/Montserrat |