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