Just updated CF2021 to update 11, Java 11.0.21. I ...
# adobej
jakobward
11/02/2023, 7:55 PMJust updated CF2021 to update 11, Java 11.0.21. I have “zeroDateTimeBehavior=convertToNull” on my datasource connection strings and it has always worked. However, I am now getting “0000-00-00 000000 is an invalid date or time string” on many pages. I thought there was a bug tracker for this and a solution, but I can’t seem to find it. I’m still using the MySQL 8.0.22 jar. Anyone?
m
Matt Dyer
11/02/2023, 7:58 PMOur connection string is changed to zeroDateTimeBehavior=convert_to_null.
Matt Dyer
11/02/2023, 7:59 PMI don't remember when that happened, or what the reason was
j
jakobward
11/02/2023, 8:05 PMNo luck.
jakobward
11/03/2023, 1:10 AMAfter further research and testing, it appears that the best practice is to utilize NULL values and NOT store default datetimes as ‘0000-00-00 000000’.
2 Views