One of the lines of the output does indeed have '2018-04-12' as expected.
On 4/12/18, 9:59 AM, "sqlite-users on behalf of Csányi Pál"
<sqlite-users-boun...@mailinglists.sqlite.org on behalf of csanyi...@gmail.com>
wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
