| Bug #5971 | CAST / CONVERT from datetime to date | ||
|---|---|---|---|
| Submitted: | 8 Oct 2004 6:37 | Modified: | 8 Oct 2004 17:48 |
| Reporter: | Harry Big | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.0.20a | OS: | Any (any) |
| Assigned to: | CPU Architecture: | Any | |
[8 Oct 2004 8:07]
Hartmut Holzgraefe
Verified on 4.0.21, 4.1.4 show the expected behaviour though ...
[8 Oct 2004 17:48]
Brian Aker
4.1 as production is to be pushed out in a couple of weeks.
Description: CAST and CONVERT from DATETIME to DATE has strange result with equal. How to repeat: SELECT CAST('2004-01-01 10:10:10' AS DATE) = CAST('2004-01-01 10:10:10' AS DATA) = 1 (right result), but SELECT CAST('2004-01-01 11:11:11' AS date) = CAST('2004-01-01 10:10:10' AS date) = 0 - hm....