On 2018/04/12 5:20 PM, Csányi Pál wrote:
Yes, this is what I am asking.
2018-04-12 17:17 GMT+02:00 Keith Medcalf <[email protected]>:
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?
Ok, now that we know what you are asking, there are some ways of doing
it easily, of which Richard's way will work perfectly.
But, some more information will be useful:
- Can there be dates later than today in the table or not?
- Can there be multiple dates for today in the table, or just the one?
- Do you need to run this query often, or is it used simply to determine
the next date available for another query (insert perhaps)?
I'm asking because I feel like the query you are asking for is achieving
something as part of a larger query or group of functions that may all
be made simpler. I could of course be wrong, but if you'd like to find
out, post the whole schema and method you are trying to make and we
could suggest what might work the fastest/easiest/best - or we might at
least confirm that you are already doing it the best way.
Cheers!
Ryan
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
