Convert date schema column

begood321

Hey Guys,

How do I convert datadeploy "DATE" schema to oracle db format to input date from metadata. Here is my date schema. Thanks for your help.

[group name="METADATA_7" table="TEAMSITE_METADATA" root-group="no" ]
[attrmap]
[column name="PATH_ID" data-type="VARCHAR2(4000)" value-from-field="path" is-replicant="no" allows-null="no"/]
[column name="ELEMENT_ID" data-type="VARCHAR2(254)" value="PUBLISH_DATE" is-replicant="no" allows-null="no"/]
[column name="DATE_DATA" data-type="DATE" value-from-field="TeamSite/Metadata/date" allows-null="yes"/]

[/attrmap]
[keys]
[primary-key]
[key-column name="ELEMENT_ID"/]
[key-column name="DATE_DATA"/]
[/primary-key]
[foreign-key parent-group="TEAMSITE_CONTENT_METADATA_1"]
[column-pair parent-column="PATH_ID" child-column="PATH_ID"/]
[/foreign-key]
[/keys]
[/group]

ISCBorisB

Hey Guys, How do I convert datadeploy "DATE" schema to oracle db format to input date from metadata. Here is my date schema. Thanks for your help. [group name="METADATA_7" table="TEAMSITE_METADATA" root-group="no" ] [attrmap] [column name="PATH_ID" data-type="VARCHAR2(4000)" value-from-field="path" is-replicant="no" allows-null="no"/] [column name="ELEMENT_ID" data-type="VARCHAR2(254)" value="PUBLISH_DATE" is-replicant="no" allows-null="no"/] [column name="DATE_DATA" data-type="DATE" value-from-field="TeamSite/Metadata/date" allows-null="yes"/] [/attrmap] [keys] [primary-key] [key-column name="ELEMENT_ID"/] [key-column name="DATE_DATA"/] [/primary-key] [foreign-key parent-group="TEAMSITE_CONTENT_METADATA_1"] [column-pair parent-column="PATH_ID" child-column="PATH_ID"/] [/foreign-key] [/keys] [/group]

Take a look at DataDeploy Admin Guide, <column> attribute data-format. Table 23 (SimpleDateFormat) shows how to use it
to declare your DCR Date/Time formatting. DD Engine then *should* be able to use this information to build proper SQL.

Note that there is also "db-datetime-format" attribute, AFAIK it's mentioned only in ddcfg.dtd. I do not think you will need
it with the Oracle internal Date Type, but just in case...