Time Zone
Time zone offset. An ANSI SQL/92 time zone offset string. Some examples are '-07:00' (Eastern), '+02:00' (Eastern Europe), and '+03:30' (India).
United States Geological Survey, National Water Information System
| Code | Sort Order | UTC Offset | DST Code | DST Name | DST Offset | Name | Description |
|---|---|---|---|---|---|---|---|
| UTC | 1 | 00:00 | null | null | null | Universal Coordinated Time | Universal Coordinated Time |
| NST | 2 | -03:30 | NDT | Newfoundland Daylight Time | -02:30 | Newfoundland Standard Time | Newfoundland |
| AST | 3 | -04:00 | ADT | Atlantic Daylight Time | -03:00 | Atlantic Standard Time (Canada) | Atlantic (Canada) |
| EST | 4 | -05:00 | EDT | Eastern Daylight Time | -04:00 | Eastern Standard Time | Eastern North America |
| CST | 5 | -06:00 | CDT | Central Daylight Time | -05:00 | Central Standard Time | Central North America |
| MST | 6 | -07:00 | MDT | Mountain Daylight Time | -06:00 | Mountain Standard Time | Mountain North America |
| PST | 7 | -08:00 | PDT | Pacific Daylight Time | -07:00 | Pacific Standard Time | Pacific North America |
| AKST | 8 | -09:00 | AKDT | Alaska Daylight Time | -08:00 | Alaska Standard Time | Alaska |
| HST | 9 | -10:00 | HDT | Hawaii Daylight Time | -09:00 | Hawaii Standard Time | Hawaii |
| ZP-11 | 10 | -11:00 | null | null | null | GMT -11 hours | GMT -11 hours |
| IDLW | 11 | -12:00 | null | null | null | International Date Line, West | International Date Line, West |
| IDLE | 12 | +12:00 | null | null | null | International Date Line, East | International Date Line, East |
| NZST | 13 | +12:00 | NZDT | New Zealand Daylight Time | +13:00 | New Zealand Standard Time | New Zealand |
| NZT | 14 | +12:00 | NZDT | New Zealand Daylight Time | +13:00 | New Zealand Time | New Zealand |
| ZP11 | 15 | +11:00 | null | null | null | GMT +11 hours | Zone GMT +11 Hours |
| AEST | 16 | +10:00 | AESST | Australia Eastern Summer Time | +11:00 | Australia Eastern Standard Time | Eastern Australia |
| EAST | 17 | +10:00 | EASST | East Australian Summer Time | +11:00 | East Australian Standard Time | East Australia |
| GST | 18 | +10:00 | null | null | null | Guam Standard Time | Guam Standard Time, Russia Zone 9 |
| LIGT | 19 | +10:00 | null | null | null | Melbourne, Australia | Melbourne |
| ACST | 20 | +09:30 | ACSST | Central Australia Summer Time | +10:30 | Central Australia Standard Time | Central Australia |
| CAST | 21 | +09:30 | CADT | Central Australia Daylight Time | +10:30 | Central Australia Standard Time | Central Australia |
| SAT | 22 | +09:30 | SADT | South Australian Daylight Time | +10:30 | South Australian Standard Time | South Australia |
| JST | 23 | +09:00 | null | null | null | Japan Standard Time | Japan Standard Time, Russia Zone 8 |
| KST | 24 | +09:00 | null | null | null | Korea Standard Time | Korea |
| MT | 25 | +08:30 | null | null | null | Moluccas Time | Moluccas |
| AWST | 26 | +08:00 | AWSST | Australia Western Summer Time | +09:00 | Australia Western Standard Time | Western Australia |
| CCT | 27 | +08:00 | null | null | null | China Coastal Time | China Coastal |
| WST | 28 | +08:00 | WDT | West Australian Daylight Time | +09:00 | West Australian Standard Time | West Australian |
| JT | 29 | +07:30 | null | null | null | Java Time | Java |
| WAST | 30 | +07:00 | WADT | West Australian Daylight Time | +08:00 | West Australian Standard Time | West Australia |
| ZP6 | 31 | +06:00 | null | null | null | GMT +6 hours | Zone GMT +6 Hours |
| ZP5 | 32 | +05:00 | null | null | null | GMT +5 hours | Zone GMT +5 Hours |
| ZP4 | 33 | +04:00 | null | null | null | GMT +4 hours | Zone GMT +4 Hours |
| IT | 34 | +03:30 | null | null | null | Iran Time | Iran |
| BT | 35 | +03:00 | null | null | null | Baghdad Time | Baghdad |
| EET | 36 | +02:00 | EETDST | Eastern Europe Daylight Time | +03:00 | Eastern Europe Standard Time | Eastern Europe, Russia Zone 1 |
| IST | 37 | +02:00 | null | null | null | Israel Standard Time | Israel |
| CET | 38 | +01:00 | CETDST | Central European Daylight Time | +02:00 | Central European Time | Central Europe |
| DNT | 39 | +01:00 | null | null | null | Dansk Normal Time | Dansk |
| DST | 40 | +01:00 | null | null | null | Dansk Standard Time (?) | Dansk |
| FST | 41 | +01:00 | FWT | French Winter Time | +02:00 | French Summer Time | French |
| MET | 42 | +01:00 | METDST | Middle Europe Daylight Time | +02:00 | Middle Europe Time | Middle Europe |
| MEWT | 43 | +01:00 | MEST | Middle Europe Summer Time | +02:00 | Middle Europe Winter Time | Middle Europe |
| MEZ | 44 | +01:00 | null | null | null | Middle Europe Zone | Middle Europe |
| NOR | 45 | +01:00 | null | null | null | Norway Standard Time | Norway |
| SET | 46 | +01:00 | null | null | null | Seychelles Time | Seychelles |
| SWT | 47 | +01:00 | SST | Swedish Summer Time | +02:00 | Swedish Winter Time | Swedish |
| GMT | 48 | 00:00 | BST | British Summer Time | +01:00 | Greenwich Mean Time | Great Britain |
| WET | 49 | 00:00 | WETDST | Western Europe Daylight Time | +01:00 | Western Europe | Western Europe |
| WAT | 50 | -01:00 | null | null | null | West Africa Time | West Africa |
| ZP-2 | 51 | -02:00 | null | null | null | GMT -2 hours | Zone GMT -2 Hours |
| ZP-3 | 52 | -03:00 | null | null | null | GMT -3 hours | Zone GMT -3 Hours |
| NFT | 53 | -03:30 | NDT | Newfoundland Daylight Time | -02:30 | Newfoundland Standard Time | Newfoundland |
| AFT | 54 | +04:30 | null | null | null | Afghanistan Time | Afghanistan |