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:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.5-beta pre-release OS:Microsoft Windows (Windows Server 2003)
Assigned to: CPU Architecture:Any

[12 May 2005 9:33] Disha
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 |
	+-------------------------------------------------------+
[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)'.