| Bug #47473 | dayofyear bug | ||
|---|---|---|---|
| Submitted: | 21 Sep 2009 8:47 | Modified: | 21 Sep 2009 8:54 |
| Reporter: | Seraphim Karyotis | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.1.36 | OS: | Linux (opensuse 11.1) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | dayofyear bug | ||
[21 Sep 2009 8:51]
Valeriy Kravchuk
Sorry, but 1968 was a leap year, wasn't it?
[21 Sep 2009 8:53]
Seraphim Karyotis
Sorry, I didn't noticed it
[21 Sep 2009 8:54]
Seraphim Karyotis
Sorry, I didn't noticed it
Description: The following query will give me different values where I aspected to get the same values. SELECT dayofyear( '1968-09-21' ) , dayofyear( '2009-09-21' ) will give: dayofyear( '1968-09-21' ) dayofyear( '2009-09-21') 265 264 How to repeat: SELECT dayofyear( '1968-09-21' ) , dayofyear( '2009-09-21' );