Maybe something like: SELECT MIN(thedate) FROM dates WHERE thedate >=
date('now');
On 4/12/18, 11:05 AM, "sqlite-users on behalf of Peter Da Silva"
<[email protected] on behalf of
[email protected]> wrote:
Ah, so if there's two days in a row that aren't school days, you need to be
able to select a day two or more days in the future.
On 4/12/18, 11:02 AM, "sqlite-users on behalf of Csányi Pál"
<[email protected] on behalf of [email protected]>
wrote:
So when I start the android app on my phone it should display the
school day at that day, or, if on that day we have not a schoolday,
then to display the next school day from the Orak table.
_______________________________________________
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