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. |
|
Entire date appears in a TEXT database column. |
|
Each date time part appears in a separate TEXT database column. |
|
Each date time part appears in a separate INTEGER database column. |
|
Copyright © 2013 Oracle and/or its affiliates. All rights reserved. |
---|