Bug #50515 error in to_Seconds() documentation
Submitted: 21 Jan 2010 16:56 Modified: 25 Jan 2010 19:16
Reporter: Kai Voigt Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5 and above OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[21 Jan 2010 16:56] Kai Voigt 
Description:
The bottom example at http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_to-seconds shows nonmatching input/output. Query contains to_seconds(), output displays to_days()

mysql> SELECT TO_SECONDS('0000-01-01');
+-----------------------+
| to_days('0000-01-01') |
+-----------------------+
|                 86400 |
+-----------------------+
1 row in set (0.00 sec)

How to repeat:
Just look at http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_to-seconds
[25 Jan 2010 19:16] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.