Home » SQL & PL/SQL » SQL & PL/SQL » date formate problem?
date formate problem? [message #299229] Sun, 10 February 2008 23:37 Go to next message
Messages: 99
Registered: August 2007
Location: usa
Hi Guru's

I have only data entry date.for example data entry date=01-JAN-06. from this date i want to display each month data means 01-jan-06,02-jan-06.... so on

how can i do it?
Re: date formate problem? [message #299231 is a reply to message #299229] Sun, 10 February 2008 23:50 Go to previous messageGo to next message
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
this question has been answered many times in this forum.search for ROW GENERATOR.
select rownum rn from dual
connect by level <=10

use this hint.

Re: date formate problem? [message #299245 is a reply to message #299229] Mon, 11 February 2008 00:35 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...Or search for "calendar".

And if the problem is only in the formatting, check TO_CHAR function.

Previous Topic: Performance analysis of package
Next Topic: Explain plan
Goto Forum:

Current Time: Sat Oct 22 02:18:24 CDT 2016

Total time taken to generate the page: 0.20087 seconds