The question you asked was: "Then how can I get only that date from the Dates table - which is equal to the current date?"
and you are now posing a second question: ">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')." Which seems like a rather long winded way of stating the problem: "I have a table with a bunch-o-dates in it. I want a query which will return, at the time the query is run, based on the comuter on which the query is run concept of today's date, today's date, if that date is in the table otherwise the tomorrow's date (based on the current concept of 'tomorrow' on the computer on which the query is run." Is this what you are asking? --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Csányi Pál >Sent: Thursday, 12 April, 2018 09:10 >To: SQLite mailing list >Subject: Re: [sqlite] SELECT with CASE > >2018-04-12 17:08 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>: >> >> 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'). >_______________________________________________ >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