|
|
|
|
Mapping date time controls—Automatic mappings
The following table indicates the settings to select in the Date Ctrl Mapping group of the Create Data Mappings dialog box to generate each type of available mapping.
To generate this mapping... |
Select... |
|---|---|
Complete date maps to a single DATE column; complete date time maps to a single DATETIME column |
DateTime in the Complete group. |
Complete date or date time maps to multiple columns |
Split Items in the Complete group. In the Split Items Type group, specify whether to map the date time parts to FIXED or TEXT columns. |
Complete date or date time maps both to a single DATE column and to multiple FIXED or TEXT columns |
Both in the Complete group. In the Split Items Type group, specify whether to map the date time parts to FIXED or TEXT columns. |
Partial date, time, or date time maps to a single TEXT column |
Text in the Partial group. |
Partial date, time, or date time maps to multiple columns |
Split Items in the Partial group. In the Split Items Type group, specify whether to map the date time parts to FIXED or TEXT columns. |
Partial date, time, or date time maps both to a single TEXT column and to multiple FIXED or TEXT columns |
Both in the Partial group. In the Split Items Type group, specify whether to map the date time parts to FIXED or TEXT columns. |
The following figure illustrates the automatic mapping of a date time control into separate columns.
