| Bug #47473 | dayofyear bug | ||
|---|---|---|---|
| Submitted: | 21 Sep 10:47 | Modified: | 21 Sep 10:54 |
| Reporter: | Seraphim Karyotis | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 5.1.36 | OS: | Linux (opensuse 11.1) |
| Assigned to: | Target Version: | ||
| Tags: | dayofyear bug | ||
[21 Sep 10:51]
Valeriy Kravchuk
Sorry, but 1968 was a leap year, wasn't it?
[21 Sep 10:53]
Seraphim Karyotis
Sorry, I didn't noticed it
[21 Sep 10: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' );