--- schema_version: "1" id: b7e96ed88be6daa385cf15d662e6c7fb333e35be95ec5d6c86c7f8793a529139 title: ccdw_dim_date 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_date.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.html source_site: developer.salesforce.com content_type: documentation content_hash: 01d361e6929443764e428ec7ea2c2df06b820346b56ffda53f59473d4e8d895c products: - Composable Storefront - Salesforce APIs --- # ccdw_dim_date This table contains various attributes related to dates, providing detailed temporal information. Each record represents a calendar date and its component parts (year, quarter, month, week, day). | Column Alias | Data Type | Key | Description | Index? | | ----------------------- | --------- | ------ | ------------------------------------------------------------------ | ------ | | `day_id (PK)` | SMALLINT | **PK** | Unique identifier for a specific day. | Yes | | `day_timestamp` | DATE | | Timestamp representing the start of the day. | Yes | | `day_of_year` | SMALLINT | | Day number within the year (1-366). | No | | `day_of_month` | SMALLINT | | Day number within the month (1-31). | Yes | | `day_of_week` | SMALLINT | | Day number within the week (for example, 1 for Monday). | No | | `day_of_week_short` | VARCHAR | | Short name for the day of the week (for example, "Mon"). | No | | `day_of_week_long` | VARCHAR | | Long name for the day of the week (for example, "Monday"). | No | | `day_display_name` | VARCHAR | | User-friendly display name for the day. | No | | `week_id` | SMALLINT | | Unique identifier for a specific week. | Yes | | `week_timestamp` | DATE | | Timestamp representing the start of the week. | Yes | | `week_of_year` | SMALLINT | | Week number within the year (1-53). | No | | `week_of_year_short` | VARCHAR | | Short representation of the week of the year. | No | | `week_of_year_long` | VARCHAR | | Long representation of the week of the year. | No | | `week_display_name` | VARCHAR | | User-friendly display name for the week. | No | | `month_id` | SMALLINT | | Unique identifier for a specific month. | Yes | | `month_timestamp` | DATE | | Timestamp representing the start of the month. | Yes | | `month_of_year` | SMALLINT | | Month number within the year (1-12). | Yes | | `month_of_year_short` | VARCHAR | | Short representation of the month of the year. | No | | `month_of_year_long` | VARCHAR | | Long representation of the month of the year (for example, 'Jan'). | No | | `month_display_name` | VARCHAR | | User-friendly display name for the month (for example, 'January'). | No | | `quarter_id` | SMALLINT | | Unique identifier for a specific quarter. | Yes | | `quarter_timestamp` | DATE | | Timestamp representing the start of the quarter. | Yes | | `quarter_of_year` | SMALLINT | | Quarter number within the year (1-4). | No | | `quarter_short` | VARCHAR | | Short representation of the quarter. | No | | `quarter_long` | VARCHAR | | Long representation of the quarter. | No | | `quarter_display_name` | VARCHAR | | User-friendly display name for the quarter. | No | | `year_id` | SMALLINT | | Unique identifier for a specific year. | Yes | | `year_timestamp` | DATE | | Timestamp representing the start of the year. | Yes | | `year_of_era` | SMALLINT | | Year number within its era. | Yes | | `year_display_name` | VARCHAR | | User-friendly display name for the year. | No | | `weekyear_id` | SMALLINT | | Unique identifier for a specific week-year. | Yes | | `weekyear_timestamp` | DATE | | Timestamp representing the start of the week-year. | Yes | | `weekyear_of_era` | SMALLINT | | Week-year number within its era. | No | | `weekyear_display_name` | VARCHAR | | User-friendly display name for the week-year. | No |