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


_HP_HTML5_bannerTitle.htm