Previous Topic

Next Topic

Book Contents

Book Index

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 data mapping setup for date time items

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.

  1. Map the date time item to a data series with a type of Text.
  2. 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.

  1. Map the date time item to a data series with a type of Text.
  2. 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.

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.