Connector Framework Server 23.4

# 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 2023 Open Text
Version 23.4 | Last updated September 2023

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 23.4

Topic Title: SqlWriterDateFormatsN