Re: How to Select last 30 days

This works if all_objects contains 30 or more rows

select sysdate - rownum from all_objects where rownum < 31

Chakravarthy KM Nalamotu wrote in message <6vahql$2l4_at_news.Hawaii.Edu>...
>Hello Oracle Users,
>Is there a way to write a SQL SELECT statement and return the last 30 days
>dates starting from SYSDATE?
>I could not think of a way to do it.
>Your response is greatly appreciated.
>Thanx,
> Kittu.
Received on Mon Oct 05 1998 - 09:25:58 CDT