MySQL Forums
Forum List  »  Newbie

Re: Error Code: 1525. Incorrect DATE value: '2022/05/32'
Posted by: Peter Brawley
Date: June 08, 2022 10:04AM

What in the world do you expect as a result from
'2022/05/32'? It's a non-existent date. I've no way to determine how MySQL 5.1 would have dealt with it. Certainly MySQL 8.0 will reject it as invalid.

You're very lucky indeed if this is the only error that ensued when you jumped from 5.1 to 8.0. The manual makes very clear thay you need to proceed stepwise through major versions, ie to 5.5 to 5.6 to 5.7 to 8.0.

No way round it--you'll need to study and fix the webapp's handling of date values.

Options: ReplyQuote


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


Sorry, you can't reply to this topic. It has been closed.

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.