On 4/12/18, Csányi Pál <[email protected]> wrote:
> 2018-04-12 17:08 GMT+02:00 Keith Medcalf <[email protected]>:
>>
>> select TheDate from Dates where TheDate == date('now');
>
> Yes, but I want the CASE because if there is no such date in the Dates
> table which is equal to the date('now') then it should return the
> date('now','+1 day').
... COALESCE((SELECT thedate FROM dates WHERE thedate==date('now')),
date('now','+1 day'))
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
