OraFAQ Forum: SQL & PL/SQL

Wed, 24 July 2002 01:26

Deepa
Messages: 269
Registered: November 2000

Senior Member

hi,
i want to display all the dates which starts from
'1-jan-2002' to '31-dec-2002' using sql statement

Wed, 24 July 2002 01:35

Saga
Messages: 51
Registered: April 2002

Member

Try this

scott@SAGA> select to_date('31-dec-2001')+rownum from all_objects where rownum < 366;

Previous Topic:	Re: Scheduling of procedures
Next Topic:	Program constructs

Goto Forum:

]

Current Time: Fri Apr 26 14:26:28 CDT 2024