CDD data mapping setup for date time items

The following table describes how to set up the mappings in a CDD data mapping definition.

CDD database result	Data series and mapping setup
Entire date appears in a DATE database column.	Map the date time item to a data series with a type of Date Time.
Entire date appears in a TEXT database column.	Map the date time item to a data series with a type of Text. In the Date-Time Data Point dialog box, select All in one column, and click OK.
Each date time part appears in a separate TEXT database column.	Map the date time item to a data series with a type of Text. In the Date-Time Data Point dialog box, select Split columns, and click OK.
Each date time part appears in a separate INTEGER database column.	Map the data time item to a data series with a type of Integer. The Central Designer application creates a separate column mapping for each date time part.