Re: selecting a date not in the range

[Peter Brawley]

Create a calendar table with a row for every relevant date ("Make a calendar table", http://www.artfulsoftware.com/queries.php), and exclusion join it to your data table ...

select ...
from calendar c
left join data d using(date)
where d.date is null;