01237: How to handle MySQL with 0000-00-00 dates

Title:

How to handle MySQL with 0000-00-00 dates

Description:

Using a sqlfetch into a sqltmpl() dimed string will not read a table from MySQL with 0000-00-00 dates. 

Resolution:

Add the following to the connection string in the sql.ini file: 

zeroDateTimeBehavior=convertToNull 

Sample connection string: 

url=jdbc:mysql://localhost:3306/asp?user=root&zeroDateTimeBehavior=convertToNull