Bug #82640 | cast string to datetime produces invalid value | ||
---|---|---|---|
Submitted: | 19 Aug 2016 3:30 | Modified: | 19 Aug 2016 7:54 |
Reporter: | 帅 Bang | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.6 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[19 Aug 2016 3:30]
帅 Bang
[19 Aug 2016 4:12]
帅 Bang
Suggested fix: insert "9-01-01 12:34:56" into column of datetime type produces 2009-01-01 12:34:56 or just failed
[19 Aug 2016 7:54]
MySQL Verification Team
Hi Bang, Thank you for the report. I would say this is duplicate of Bug #82642(with strict mode - invalid date inserted when single digit year used). Thanks, Umesh