MySQL Forums
Forum List  »  Newbie

Error Code: 1525. Incorrect DATE value: '2022/05/32'
Posted by: zhu guan
Date: June 08, 2022 07:19AM

I have had a Website working for 7 years and have had no problems
until at the weekend I replace my MySQL version with a newer one.

MySQL version (old): MySQL 5.1
MySQL version (new): MySQL 8.0.28

I run following code in MySQL 5.1, it return my expected result.

SELECT * FROM tbl_compare_test where tbl_compare_test.col_date >= '2022/05/32'

However after i migrated to MySQL 8.0.28, i hit following error:

********** Error **********
Error Code: 1525. Incorrect DATE value: '2022/05/32'
********** Error **********

The Website application is large and rewrite is a terrible job.
And i don't know how to quickly and accurately find out the SQL with the problem.

Is there any easy way to maintain compatibility?

Options: ReplyQuote


Subject
Written By
Posted
Error Code: 1525. Incorrect DATE value: '2022/05/32'
June 08, 2022 07:19AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.