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
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
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
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
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 :