| Bug #15113 | Dates in where clause | ||
|---|---|---|---|
| Submitted: | 21 Nov 2005 21:40 | Modified: | 22 Nov 2005 0:25 |
| Reporter: | Marvin Eads | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
| Version: | 4.1.14 NT MySQL | OS: | Windows (Win2K) |
| Assigned to: | CPU Architecture: | Any | |
[21 Nov 2005 23:44]
Hartmut Holzgraefe
i assume "complaintcreated" is actually a DATETIME field? in that case "2005-11-03" is converted to "2005-11-03 00:00:00" and you should check for ' < "2005-11-04" ' instead
[22 Nov 2005 0:25]
Marvin Eads
Heh, I'm such an idiot. Sorry about that.
Description: SELECT c.complaintacknowledged, c.complaintresolved, c.complaintclosed, c.assignedto, s.state, s.name, s.phonenumber, c.dateappended, c.complaintcreated, c.trackingnumber, c.servicetype, c.type, c.originator, c.complaintkey FROM cfs_customers s, cfs_complaints c WHERE c.complaintkey AND c.customerkey=s.customerkey AND c.del=0 AND c.complaintcreated >= '2005-11-01' AND c.complaintcreated <= '2005-11-03' ORDER BY c.trackingnumber Does not return values for date 2005-11-03 How to repeat: ran through ODBC 3.51