Bug #72124 document the optional parameter for SYSDATE()

• Submitted: 25 Mar 2014 18:29
• Modified: 26 Mar 2014 17:39
• Reporter: Axel Schwenke
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6.15
• OS: Any
• Assigned to: Paul DuBois
• CPU Architecture: Any

[25 Mar 2014 18:29] Axel Schwenke

Description:
According to the manual at
http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_sysdate

the SYSDATE() function does not take a parameter. Nowever just like NOW() and compagnons, SYSDATE() accepts an optional parameter for the fractional seconds precision.

How to repeat:
mysql>select sysdate(6);
+----------------------------+
| sysdate(6)                 |
+----------------------------+
| 2014-03-25 19:27:23.250060 |
+----------------------------+
1 row in set (0,00 sec)

Suggested fix:
update the documentation

[26 Mar 2014 7:23] MySQL Verification Team

Hello Axel,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[26 Mar 2014 17:39] 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.