Is there a way to generate a list of dates between a certain range? For instance, show me all dates between January 1, 2001 and today? I'm trying to a create a Date data source for use in Transformer.
For small, fixed size record sets you could probably play games with UNIONs and your database's dummy table (e.g. DUAL in Oracle), but realistically you're pretty much going to need something in a real table...either one populated with all the potential dates you would want in your ranges, or one containing records with sequential integers which themselves have a range as large as the largest you would want for your dates (so you could calculate your dates as an offset to the start date).
Thanks. I ended up creating a procedure to update a table with a series of dates. Works great.