KB#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 

Last Modified: 03/15/2012 Product: BASIS BBj ODBC Driver Operating System: N/A

BASIS structures five components of their technology into the BBx Generations.