Bug #108782 | Mysql str_to_date can correct convert for '2022-11-30' | ||
---|---|---|---|
Submitted: | 14 Oct 2022 11:01 | Modified: | 14 Oct 2022 14:21 |
Reporter: | sundy sun | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Data Types | Severity: | S2 (Serious) |
Version: | 5.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[14 Oct 2022 11:01]
sundy sun
[14 Oct 2022 14:21]
MySQL Verification Team
HI Mr. sun, Thank you for your bug report. We have repeated the behaviour and we think that you are correct in your analysis. We can not yet know whether this will remain a code bug or a documentation bug. Verified as reported.
[14 Oct 2022 14:21]
MySQL Verification Team
Correct status.
[28 Apr 5:31]
MySQL Verification Team
Current trunk says this: mysql> select str_to_date('31/11/22', '%d/%m/%Y') d1,str_to_date('2021-11-31', '%Y-%m-%d') d2, EXTRACT(DAY FROM '2021-11-31') d3,version() from dual; +------------+------------+------+-----------+ | d1 | d2 | d3 | version() | +------------+------------+------+-----------+ | 2022-11-31 | 2021-11-31 | NULL | 8.1.0 | +------------+------------+------+-----------+ 1 row in set, 1 warning (0.00 sec) mysql> show warnings; +---------+------+----------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------+ | Warning | 1292 | Incorrect datetime value: '2021-11-31' | +---------+------+----------------------------------------+ 1 row in set (0.00 sec)