invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMTIMEZONES: Data Dictionary Time Zones

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Time Zones

Timezones.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMTIMEZONES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ABBREVIATION varchar2(6) Abbreviation Abbreviation.
COUNTRY_CODE varchar2(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 varchar2(30) Name Name in English.
START_DATE datetime Start Date Start time.

Keys

Key Column Refers to Kind Description
SYSTEMTIMEZONES_COUNTRY_CODE_SYSTEMCOUNTRIES_fk COUNTRY_CODE SYSTEMCOUNTRIES.ISO_CODE Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: