Hi Simon,
2018-04-12 14:32 GMT+02:00 Simon Slavin <[email protected]>:
> On 12 Apr 2018, at 1:25pm, Csányi Pál <[email protected]> wrote:
>
>> SELECT CASE TheDate = date('now') WHEN TheDate ...
>
> I don't think that's what you wanted. Perhaps
>
> SELECT CASE TheDate WHEN date('now') ...
>
> But you should test the output of "date('now')" to make sure it is in the
> format you want.
The output of "date('now') is in format I want:
SELECT date('now');
2018-04-12
I tried this:
SELECT CASE TheDate WHEN date('now') THEN TheDate ELSE date('now','+1
day') END TheDate FROM Dates;
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-13
2018-04-12
2018-04-13
2018-04-13
2018-04-13
but I expect the output like this:
2018-04-12
because today date is:
2018-04-12
What am I missing here?
--
Best, Pali
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
