Specifies the text pattern the provider uses when it parses or writes DATE values.

Data Type

string

Default Value

""

Remarks

Most applications don't use this setting because DATE parameters are sent to Azure Synapse as native values, not strings. You need it only when the driver has to read or write dates as text. For example, CSV-based bulk loads, flat-file exports, or log files that downstream tools will ingest.

Common patterns include:

• yyyy-MM-dd
• MM/dd/yyyy
• dd-MMM-yyyy
• yyyyMMdd

Set a pattern that matches the files you must consume or produce. Otherwise the driver may fail to parse incoming dates or generate strings your target system rejects. This property is helpful when the data you share or receive is locked into a regional or legacy date layout and you want to avoid a separate conversion step.