Return Minimal Date For Zero Date

ZeroDateToMin

Key Name	Default Value	Required
ZeroDateToMin	0	No

Description

This option specifies whether the connector translates zero dates (where the month or day is 0) to a date value that is supported by ODBC. For example, when this option is enabled, the date (0000-00-00) is translated to (0000-01-01).

• Enabled (1)1: The connector translates the zero dates to a date value that is supported by ODBC.
• Disabled (0)0: The connector returns zero dates as NULL.

Related topics

• Using a Connection String
• Configuring Cursor and Result Options
• Creating a Data Source Name
• Configuring a DSN-less Connection
• Cursor and Result Configuration Options