ODBC Connector 25.2
ODBC Connector Help

# ValueFormat

The `<ValueFormat>` element converts field or attribute values from one format to another.

Attribute | Description
--- | ---
`format` | The input format.
`targetformat` | The target format, when you set `type` to `customdate`.
`type` | The data format to standardize on. You can specify: `autndate`, to convert into the Knowledge Discovery AUTNDATE format. `customdate`, to convert into a custom format specified by the `targetformat` attribute.

The following example changes the format of a field named "dateField", from a value such as `2020-10-27 15:11:32` to `AUTNDATE` format.

    <FieldStandardization>
        <Field name="dateField">
             <ValueFormat format="YYYY-MM-DD HH:NN:SS" type="autndate" />
        </Field>
    </FieldStandardization>

Copyright 2025 Open Text
Version 25.2 | Last updated April 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery ODBC Connector 25.2

Topic Title: ValueFormat