--- schema_version: "1" id: 9ba7c12783336310235548406ce133793dd3d544fa83d7e0ae35e2cd3d0401e3 title: ccdw_dim_timezone collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_dim_timezone.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_timezone.html source_site: developer.salesforce.com content_type: documentation content_hash: 6e0efa82db720d7079b942218a080cca8f2a7bd01b6813387ad719eab8552154 products: - Composable Storefront - Salesforce APIs --- # 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 |