Connector Framework Server 12.11

# SqlWriterDateFormatsN

A list of date formats that are used in your documents.

When you write a date value from a document field to a column using the DATE_TIME data type, the `SqlWriter` task must convert the date into a standard format. The task therefore attempts to match the date in the document field against these date formats. The task checks the date against each format in order: `SqlWriterDateFormats0` first, followed by `SqlWriterDateFormats1`, `SqlWriterDateFormats2`, and so on.

NOTE: The `SqlWriterDateFormatsN` parameter applies to all document fields. For example, the `SqlWriter` task might match a date in the field `SqlWriterFieldNames0` to the format ``SqlWriterDateFormats3``.

Type: | String
Default: | `YYYY-SHORTMONTH-DD HH:NN:SS YYYY/MM/DD HH:NN:SS DD/MM/YYYY HH:NN:SS YYYY-MM-DD HH:NN:SS DD-MM-YYYY HH:NN:SS YYYY-MM-DDTHH:NN:SS`
Required | No
Configuration Section: | Any section you have defined for `SqlWriter` task settings
Example: | `SqlWriterDateFormats0=DD/MM/YYYY HH:NN:SS SqlWriterDateFormats1=D+/M+/YYYY`
See Also: | SqlWriterFieldNamesN SqlWriterColumnNamesN

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.11 | Last updated February 2022

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 swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Connector Framework Server 12.11

Topic Title: SqlWriterDateFormatsN