Yes, this is what I am asking.
2018-04-12 17:17 GMT+02:00 Keith Medcalf <[email protected]>: > > 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- >>[email protected]] 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 <[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'). >>_______________________________________________ >>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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
