| Bug #10576 | If value is added to 'STR_TO_DATE(str,format)' , produces invalid result. | ||
|---|---|---|---|
| Submitted: | 12 May 2005 9:33 | Modified: | 13 May 2005 8:38 |
| Reporter: | Disha | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.5-beta pre-release | OS: | Windows (Windows Server 2003) |
| Assigned to: | CPU Architecture: | Any | |
[12 May 2005 10:25]
MySQL Verification Team
Verified on Linux.
[13 May 2005 8:38]
Sergei Golubchik
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: see the explanation in the bug#10571
[13 May 2005 9:28]
Disha
Please reflect the appropriate explaination in Manual when we add the value to the returned value of function 'STR_TO_DATE(str,format)'.
Description: If value is added to function 'STR_TO_DATE(str,format)' produces invalid result. It has to give syntax error or appropriate result. How to repeat: 1. delimiter // 2. create database test// 3. use test 4. set @@sql_mode='traditional'// 5. select str_to_date('31.12.2005 08.40','%d.%m.%Y %H.%i')+2000// 6. Execution of step (5) displays the result as, +-------------------------------------------------------+ | str_to_date('31.12.2005 08.40','%d.%m.%Y %H.%i')+2000 | +-------------------------------------------------------+ | 4005 | +-------------------------------------------------------+ Expected Result: The function 'STR_TO_DATE(str,format)' should return appropriate result. Actual Result : The execution displays the result as, +-------------------------------------------------------+ | str_to_date('31.12.2005 08.40','%d.%m.%Y %H.%i')+2000 | +-------------------------------------------------------+ | 4005 | +-------------------------------------------------------+