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
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
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
dhananjay
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.


regards,
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: 64103
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.

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


Current Time: Sat Dec 03 04:01:31 CST 2016

Total time taken to generate the page: 0.12074 seconds