0000-00-00 00:00:00' can not be represented as java.sql

Cold Fusion 10 or higher may give the following error:

0000-00-00 00:00:00' can not be represented as java.sql

Add the following to the DSN connection

 

zeroDateTimeBehavior=convertToNull

 
  • Cold Fusion, DSN
  • 477 Users Found This Useful
Was this answer helpful?