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.