Code review comment for lp:~dkessel/ubuntu-qa-website/fix-end-date-of-date-range-queries
Revision history for this message
| Daniel Kessel (dkessel) wrote | # |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
73416ba
(Get the code!)
Yes, the SQL query was the issue. The old statement was something like (example with today) "... AND date <= '2015/06/01'", which does not match datetime values like "2015/06/01 00:11:22". The new statement is something like "... AND date < '2015/06/02'", which will include all of today's results, but none of tomorrow's.