How do i generate a sequence of consecutive dates between 2 dates in a
single query?
For example......between '01-01-2003' and '01-04-2003' the result should be
01-01-2003
01-02-2003
01-03-2003
01-04-2003
I don't want to use any pgsql or any othere procedural languag. The result
should be got in a single sql statement. Like in oracle I can do it as
follows by using one of my tables...
select (rownum+to_date('01-01-2000 00:00:00','mm-dd-yyyy hh24:mi:ss'))
timesheetdate
from skills having (rownum+to_date('01-01-2000 00:00:00','mm-dd-yyyy
hh24:mi:ss')) < to_date('01-01-2010 00:00:00','mm-dd-yyyy hh24:mi:ss')
group by rownum;
There is nothing like a rownum in postgres, so how can I do the same in
postgres?
Madhavi