A custom table is maintained in the BMC product databases with the name ANA_TIMEZONE_INFO. This table is created during the installation process of BMC Analytics for BSM.
The ANA_TIMEZONE_INFO table is used by the FN_ADJUSTED_DATE function to convert epoch time values to human-readable date and time values, depending upon the preferred time zone selected by customer during installation.
During the installation, you select the preferred time zone for the reports, and the REGION_FLAG for that time zone is set to Y for the selected timezone.
ANA_TIMEZONE_INFO table
Column name | Data type | Description |
---|---|---|
TIMEZONE_LOC_ID | NUMBER | Timezone ID |
COUNTRY | VARCHAR2(50 BYTE) | Country name |
COUNTRY_CODE | VARCHAR2(50 BYTE) | Country code |
REGION | VARCHAR2(50 BYTE) | Specific region in a country based on time zone |
REGION_CODE | VARCHAR2(50 BYTE) | Region code |
DST_FLAG | VARCHAR2(1 BYTE) | Flag indicating whether the region observes DST (Y) or not (N) |
REGION_FLAG | VARCHAR2(1 BYTE) | Set Y for the region which client is interested in |
START_YEAR | VARCHAR2(50 BYTE) | Daylight Saving Time (DST) starting year |
START_MONTH_LAST_DT | VARCHAR2(50 BYTE) | DST starting month, last date (For example, if the start month is April, the value is 31-APRIL.) |
START_WEEK_DAY | VARCHAR2(50 BYTE) | DST starting week, day name in a week |
START_WEEK | VARCHAR2(10 BYTE) | DST starting week number (First/Second/Third/Fourth/Last) in a month |
END_YEAR | VARCHAR2(50 BYTE) | DST ending year |
END_MONTH_LAST_DT | VARCHAR2(50 BYTE) | DST ending month, last date (For example, if the end month is September, the value is 30-SEPTEMBER.) |
END_WEEK_DAY | VARCHAR2(50 BYTE) | DST ending week, day name in a week |
END_WEEK | VARCHAR2(10 BYTE) | DST ending week, number in a month |
START_MONTH_LAST_NUM | VARCHAR2(50 BYTE) | DST starting month, last date number (for example, 31-04 for April) |
START_WEEK_DAY_NUM | NUMBER | DST starting week day number in a week (for example, 01 for Sunday, 02 for Monday) |
START_WEEK_NUM | NUMBER | DST starting week number in a month (for example, 01 for first start_week_number) |
END_MONTH_LAST_NUM | VARCHAR2(50 BYTE) | DST ending month last date number (for example, 30-09 for September) |
END_WEEK_DAY_NUM | NUMBER | DST ending week day number in a week (for example, 01 for Sunday, 02 for Monday) |
END_WEEK_NUM | NUMBER | DST ending week number in a month (for example, 02 for second end_week_number) |
DST_START_TIME | VARCHAR2(20 BYTE) | When DST starts for this region |
DST_END_TIME | VARCHAR2(20 BYTE) | When DST ends for this region |
GMT_START_TIME | VARCHAR2(20 BYTE) | Equivalent GMT start time for this region (DST_Start_Time + GMT_TimeDifference) |
GMT_END_TIME | VARCHAR2(20 BYTE) | Equivalent GMT end time for this region (DST_End_Time + GMT_TimeDifference) |
GMT_TIMEDIFFERENCE | VARCHAR2(10 BYTE) | Time difference (offset) from GMT for this region |
GMT_HRS_Mins | NUMBER | Time difference (offset) in number from GMT for this region |