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