Main Menu

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.

View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel