Bug #26005 Bad microseconds in EXTRACT() example

Submitted: 1 Feb 2007 10:17 Modified: 1 Feb 2007 16:55
Reporter: Jakub Vrána (Candidate Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Paul DuBois CPU Architecture:Any

[1 Feb 2007 10:17] Jakub Vrána 
Description:
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.