SYSTEMTIMEZONES: Data Dictionary Timezones |
Timezones.
Catalog: DataDictionary
Schema: Invantive
Alias: tze
Label: Timezones
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SYSTEMTIMEZONES are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ABBREVIATION |
string(6) |
Abbreviation |
☑ |
Abbreviation. |
COUNTRY_CODE |
string(2) |
Country Code |
☑ |
ISO country code. |
DST |
boolean |
Daylight Saving Time |
☑ |
Has DST. |
END_DATE |
datetime |
End Date |
☐ |
End time (exclusive). |
GMT_OFFSET |
int32 |
GMT Offset |
☑ |
GMT offset. |
NAME |
string(30) |
Name |
☑ |
Name in English. |
START_DATE |
datetime |
Start Date |
☑ |
Start time. |
18-10-2024 06:49 Version 24.0.345-PROD+4945