2018-04-12 16:51 GMT+02:00 Peter Da Silva <peter.dasi...@flightaware.com>: > You're asking for "ELSE date('now','+1 day')" which is 2018-04-13 which is > what you're getting, no?
Yes, indeed. But I thought the first part would be done: CASE TheDate WHEN date('now') THEN TheDate that is, if the TheDate is = date('now') THEN it should select that TheDate which is equal to the current date: date('now'), no? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users