> I need help to build a statement in order to select all days free from > events in a specific time range.
This kind of task should be implemented in your application. SQL wasn't intended for and can't solve such tasks. Pavel On Wed, May 18, 2011 at 4:06 PM, Danilo Cicerone <cyds...@gmail.com> wrote: > Hi to all, > I need help to build a statement in order to select all days free from > events in a specific time range. > E.g.: > > - Range(YYYY-MM-DD) from 2011-01-01 to 2011-02-01. > - Event 1 from 2011-01-02 to 2011-01-08 > - Event 2 from 2011-01-06 to 2011-01-12 > - Event 3 from 2011-01-18 to 2011-01-21 > > Resulting Days Free: > - from 2011-01-01 to 2011-01-01 > - from 2011-01-13 to 2011-01-17 > - from 2011-01-22 to 2011-02-01 > > Thanks for your help in advance. > Danilo > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
