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

Reply via email to