IBM Support

nzsql supported timezones

Question & Answer


Question

What timezones are supported for Netezza's nzsql?

Answer

The following timezones are supported in Postgres:

NZDT +13:00 New Zealand Daylight-Saving Time
IDLE +12:00 International Date Line, East
NZST +12:00 New Zealand Standard Time
NZT +12:00 New Zealand Time
AESST +11:00 Australia Eastern Summer Standard Time
ACSST +10:30 Central Australia Summer Standard Time
CADT +10:30 Central Australia Daylight-Saving Time
SADT +10:30 South Australian Daylight-Saving Time
AEST +10:00 Australia Eastern Standard Time
EAST +10:00 East Australian Standard Time
GST +10:00 Guam Standard Time, Russia zone 9
LIGT +10:00 Melbourne, Australia
SAST +09:30 South Australia Standard Time
CAST +09:30 Central Australia Standard Time
AWSST +09:00 Australia Western Summer Standard Time
JST +09:00 Japan Standard Time, Russia zone 8
KST +09:00 Korea Standard Time
MHT +09:00 Kwajalein Time
WDT +09:00 West Australian Daylight-Saving Time
MT +08:30 Moluccas Time
AWST +08:00 Australia Western Standard Time
CCT +08:00 China Coastal Time
WADT +08:00 West Australian Daylight-Saving Time
WST +08:00 West Australian Standard Time
JT +07:30 Java Time
ALMST +07:00 Almaty Summer Time
WAST +07:00 West Australian Standard Time
CXT +07:00 Christmas (Island) Time
MMT +06:30 Myanmar Time
ALMT +06:00 Almaty Time
MAWT +06:00 Mawson (Antarctica) Time
IOT +05:00 Indian Chagos Time
MVT +05:00 Maldives Island Time
TFT +05:00 Kerguelen Time
AFT +04:30 Afghanistan Time
EAST +04:00 Antananarivo Summer Time
MUT +04:00 Mauritius Island Time
RET +04:00 Reunion Island Time
SCT +04:00 Mahe Island Time
IRT, IT +03:30 Iran Time
EAT +03:00 Antananarivo, Comoro Time
BT +03:00 Baghdad Time
EETDST +03:00 Eastern Europe Daylight-Saving Time
HMT +03:00 Hellas Mediterranean Time (?)
BDST +02:00 British Double Standard Time
CEST +02:00 Central European Summer Time
CETDST +02:00 Central European Daylight-Saving Time
EET +02:00 Eastern European Time, Russia zone 1
FWT +02:00 French Winter Time
IST +02:00 Israel Standard Time
MEST +02:00 Middle European Summer Time
METDST +02:00 Middle Europe Daylight-Saving Time
SST +02:00 Swedish Summer Time
BST +01:00 British Summer Time
CET +01:00 Central European Time
DNT +01:00 Dansk Normal Tid
FST +01:00 French Summer Time
MET +01:00 Middle European Time
MEWT +01:00 Middle European Winter Time
MEZ +01:00 Mitteleurop?ische Zeit
NOR +01:00 Norway Standard Time
SET +01:00 Seychelles Time
SWT +01:00 Swedish Winter Time
WETDST +01:00 Western European Daylight-Saving Time
GMT 00:00 Greenwich Mean Time
UT 00:00 Universal Time
UTC 00:00 Universal Coordinated Time
Z 00:00 Same as UTC
ZULU 00:00 Same as UTC
WET 00:00 Western European Time
WAT -01:00 West Africa Time
FNST -01:00 Fernando de Noronha Summer Time
FNT -02:00 Fernando de Noronha Time
BRST -02:00 Brasilia Summer Time
NDT -02:30 Newfoundland Daylight-Saving Time
ADT -03:00 Atlantic Daylight-Saving Time
AWT -03:00 (unknown)
BRT -03:00 Brasilia Time
NFT -03:30 Newfoundland Standard Time
NST -03:30 Newfoundland Standard Time
AST -04:00 Atlantic Standard Time (Canada)
ACST -04:00 Atlantic/Porto Acre Summer Time
EDT -04:00 Eastern Daylight-Saving Time
ACT -05:00 Atlantic/Porto Acre Standard Time
CDT -05:00 Central Daylight-Saving Time
EST -05:00 Eastern Standard Time
CST -06:00 Central Standard Time
MDT -06:00 Mountain Daylight-Saving Time
MST -07:00 Mountain Standard Time
PDT -07:00 Pacific Daylight-Saving Time
AKDT -08:00 Alaska Daylight-Saving Time
PST -08:00 Pacific Standard Time
YDT -08:00 Yukon Daylight-Saving Time
AKST -09:00 Alaska Standard Time
HDT -09:00 Hawaii/Alaska Daylight-Saving Time
YST -09:00 Yukon Standard Time
MART -09:30 Marquesas Time
AHST -10:00 Alaska/Hawaii Standard Time
HST -10:00 Hawaii Standard Time
CAT -10:00 Central Alaska Time
NT -11:00 Nome Time
IDLW -12:00 International Date Line, West

The only timezone which could not be set in the Netezza environment was CAST +09:30 Central Australia Standard Time.

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ250358

Document Information

Modified date:
17 October 2019

UID

swg21576792