Cristian Glodeanu
4,030 PointsLoans Due solution
Hi,
The Loans Due practice question was nice. I've researched and came up with this:
SELECT * FROM loans WHERE return_by BETWEEN DATE('now', 'weekday 0', '-6 days') AND DATE('now', 'weekday 0') AND returned_on IS null;
Did anybody found a cleaner/more compact solution? :)
Cheers!
8 Answers
Denny Schouten
8,242 PointsHi this is my solution SELECT * FROM loans WHERE STRFTIME("%W", return_by) = STRFTIME("%W", "now") AND returned_on IS NULL;
Tee Abdul
8,411 PointsSELECT * FROM loans WHERE return_by BETWEEN DATE("now") AND DATE("now", "+7 days") AND returned_on IS NULL;
Alexandru Palita
14,254 PointsSELECT * FROM loans WHERE returned_on > return_by OR returned_on IS NULL;
:))))
Sean Flanagan
33,224 PointsHow's mine?
SELECT * FROM loans WHERE return_by BETWEEN DATE("now", "+1 week") AND returned_on IS NULL;
Yassin Chiguer
5,228 Pointsselect * from loans where return_by BETWEEN DATE("now", "+ 7days") and returned_on is null
DeAndre' McDade
2,937 PointsSELECT *
FROM loans
WHERE return_by BETWEEN DATE('now', 'weekday 0') AND DATE('now', 'weekday 0', "+6 days")
AND returned_on IS NULL
;
Roger Dailey
14,887 PointsThis is how I wrote it: SELECT * FROM loans WHERE return_by BETWEEN DATE("now", "-1 day") AND DATE("now", "+6 days") AND returned_on IS NULL;
When I completed this it was the week of 02/13/17 through 02/19/17 and the day I completed it on was 02/14/17.
Jonatan Spahn
6,362 PointsI did this on today so 3/23 and this is how I did it.
SELECT * FROM loans WHERE return_by BETWEEN DATE("now", "-7 days") AND DATE("now", "+1 days");