Open topic with navigation

# 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 2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm