Bug #26005 Bad microseconds in EXTRACT() example
Submitted: 1 Feb 2007 10:17 Modified: 1 Feb 2007 16:55
Reporter: Jakub Vrana (Candidate Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Paul DuBois CPU Architecture:Any

[1 Feb 2007 10:17] Jakub Vrana
There is a missing zero in example "SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.00123');" returning "123" in documentation of EXTRACT() function in Date and Time Functions chapter.

How to repeat:
Run the example.

Suggested fix:
EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.000123')
[1 Feb 2007 11:13] MySQL Verification Team
Thank you for the bug report.
[1 Feb 2007 16:55] 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.