There are 1 item(s) tagged with the keyword "mysql".
- Displaying: 1 - 1 of 1
- 1. java.sql.SQLException: Value ''0000-00-00'' can not be represented as java.sql.Date
Got strange issue today while working with mySql and ColdFusion. This might be old issue but we never face issue since we normally work with MS Sql and I think this one is second/third project which use mysql as database. Error says java.sql.SQLException: value '.........with long garbage string and special characters......' can not be represented as java.sql.Date and this is due to mysql store 0000-00-00 stored as Null value of date.
- By Pritesh