| Bug #25241 | Error in difference of dates | ||
|---|---|---|---|
| Submitted: | 22 Dec 2006 10:29 | Modified: | 22 Dec 2006 11:35 |
| Reporter: | Sidnei Cesar Coltre | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: C API (client library) | Severity: | S3 (Non-critical) |
| Version: | 5.0.30 | OS: | Linux (linux-Gentoo - 2.6) |
| Assigned to: | CPU Architecture: | Any | |
[22 Dec 2006 11:35]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Read about how function DATE_FORMAT working at http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Description: select date_format(from_days(to_days(current_date())- to_days('1938-12-28')),'%ya%mm%dd') Hi, when execute this sql, the result is 67a12m26d How to repeat: ever