--- schema_version: "1" id: 640b97e50e9a3e80ef8a3329ec4a2b0ecdb83eee6588526a17da99d5b26e0229 title: ccdw_dim_time 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_time.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_time.html source_site: developer.salesforce.com content_type: documentation content_hash: 9b2a0a21dbc7c9a5db5b7a0f1d29fe2229f400ac027d8a4e1554297465568f18 products: - Composable Storefront - Salesforce APIs --- # ccdw_dim_time This table contains various attributes related to time, providing detailed temporal information within a day. Each row represents a minute of a clock. | Column Alias | Data Type | Key | Description | Index? | | ----------------------------- | --------- | ------ | -------------------------------------------------------------------------------- | ------ | | `time_id (PK)` | SMALLINT | **PK** | Unique identifier for a specific time. | Yes | | `minute_of_day` | SMALLINT | | Minute number within the day (0-1439). | Yes | | `minute_of_hour` | SMALLINT | | Minute number within the hour (0-59). | No | | `hour_of_day` | SMALLINT | | Hour number within the day (0-23, 24-hour format). | Yes | | `hour_of_half_day` | SMALLINT | | Hour number within the half-day (1-12). | No | | `clock_hour_of_day` | SMALLINT | | Clock hour within the day (1-24). | No | | `clock_hour_of_halfday` | SMALLINT | | Clock hour within the half-day (1-12). | No | | `halfday_of_day` | SMALLINT | | Indicator for AM/PM (for example, 0 for AM, 1 for PM). | No | | `halfday_of_day_display_name` | VARCHAR | | Display name for half-day (for example, "AM", "PM"). | No | | `time_display_name_24hr` | VARCHAR | | User-friendly display name for time in 24-hour format (for example, "14:30"). | No | | `time_display_name_12hr` | VARCHAR | | User-friendly display name for time in 12-hour format (for example, "11:22 PM"). | No |