[GENERAL] Query to find list of dates between two dates

2010-02-05 Thread aravind chandu
Hello guys, can you please help me with the following query I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this 12/1/2009 12/2/2009 12/3/2009 . . . . . 12/31/2009 Note : Assume that there is no table

Re: [GENERAL] Query to find list of dates between two dates

2010-02-05 Thread Alban Hertroys
On 5 Feb 2010, at 11:06, aravind chandu wrote: Hello guys, can you please help me with the following query I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this 12/1/2009 12/2/2009 12/3/2009

Re: [GENERAL] Query to find list of dates between two dates

2010-02-05 Thread Andre Lopes
You could use a query like this one here: and table.BEGIN_DATE = pREFERENCE_END_DATE and (table.END_DATE = pREFERENCE_BEGIN_DATE or table.END_DATE is null) Best Regards

Re: [GENERAL] Query to find list of dates between two dates

2010-02-05 Thread Ivan Sergio Borgonovo
On Fri, 5 Feb 2010 02:06:12 -0800 (PST) aravind chandu avin_frie...@yahoo.com wrote: Hello guys, can you please help me with the following query I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this

Re: [GENERAL] Query to find list of dates between two dates

2010-02-05 Thread Albe Laurenz
aravind chandu wrote: can you please help me with the following query I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this 12/1/2009 12/2/2009 12/3/2009 . . . . . 12/31/2009 Note :