query or function

I need to create a set for use in a query that includes all dates between a
start and ending date. Is this something I can do with a simple sql
statement or do I need to make a function for this?