> Why do you expect 1988-01-04 et al to be excluded? These dates meet your > condition of falling between 09/01 and 04/01 - they should appear _somewhere_ > in the resultset.
I second that. Your question in the first place says about order of records, but if you indeed for some reason want to exclude data at the beginning of the first year you have to add to your WHERE clause something like this: AND (Year > (SELECT MIN(Year) FROM table_name) OR Month > start_month OR Day >= start_day) Pavel On Wed, Oct 14, 2009 at 11:59 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Rick Ratchford wrote: >> Tried that. It doesn't work. >> >> For example, when I used 09/01 as my start and 04/01 as my ending, what I >> got back was: >> >> 1988 1 4 >> 1988 1 5 >> 1988 1 6 >> ... >> ... >> >> Instead of: >> >> 1988 9 1 >> 1988 9 2 > > Why do you expect 1988-01-04 et al to be excluded? These dates meet your > condition of falling between 09/01 and 04/01 - they should appear _somewhere_ > in the resultset. > > Igor Tandetnik > > > _______________________________________________ > 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
