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"
<[email protected] on behalf of [email protected]>
wrote:
2018-04-12 16:51 GMT+02:00 Peter Da Silva <[email protected]>:
> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
