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
|
| Required | No |
| Configuration Section: | Any section you have defined for SqlWriter task settings |
| Example: | SqlWriterDateFormats0=DD/MM/YYYY HH:NN:SS
|
| See Also: |
|
|