ccdw_dim_timezone
This table contains information about different time zones.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
timezone_id (PK) | SMALLINT | PK | Unique identifier for a time zone. | Yes |
ntimezone_id | VARCHAR | Normalized time zone identifier. | Yes | |
display_name | VARCHAR | User-friendly display name for the time zone. | No | |
standard_time_short | VARCHAR | Short abbreviation for standard time (for example, "EST"). | No | |
daylight_time_short | VARCHAR | Short abbreviation for daylight saving time (for example, "EDT"). | No | |
standard_time_long | VARCHAR | Long name for standard time (for example, "Eastern Standard Time"). | No | |
daylight_time_long | VARCHAR | Long name for daylight saving time (for example, "Eastern Daylight Time"). | No | |
utc_offset_millis | INTEGER | Offset from UTC in milliseconds. | No | |
observes_dst | BOOLEAN | Boolean indicating if the time zone observes Daylight Saving Time. | No | |
dst_savings_millis | INTEGER | Daylight Saving Time savings in milliseconds. | No |