gr8..Thank u vary much for this excellent query

Beautiful query. 10x.

excelent query

marvelleouds query

Thank u vary much

10x 4 the idea

Select TO_CHAR(v.year,'YYYY') as year
from (select add_months (to_date('01/01/1980','DD/MM/YYYY'), 12*Level-1)
Year FROM Dual
CONNECT BY Level <= trunc(MONTHS_BETWEEN(trunc (sysdate, 'YEAR'), to_date('01/01/1980','MM/DD/YYYY'))/12) + 1
) v
order by year desc

Thats really a excellent query i would have wasted a lot of time without this thank u

thnx buddy, was in very need of it

Thank you so much. I was struggling to bring out this.

Excellent query, very helpful.

Very slick!

The following is better:

SELECT TO_CHAR(ADD_MONTHS(TRUNC(TO_DATE('30-10-2009', 'dd-mm-yyyy'), 'MM'), 1*LEVEL -1)) MONTH
FROM DUAL
CONNECT BY Level <= MONTHS_BETWEEN(TRUNC(TO_DATE ('02-12-2009', 'dd-mm-yyyy'),'MM'), TRUNC(TO_DATE ('22-10-2009', 'dd-mm-yyyy'),'MM')) + 1
ORDER BY MONTH

This is awesome !

Thats is really cool.. but hwo to make it include nov 2008 ?

wow, thank you very very much, this query help me very very very much.

hen sha ..

Hey dear your blog is very much rocking and stunning. This blog has main attraction and high quality features. Due to the latest posts, this blog is relatively famous among the readers of allover the world. You have provided enough information on many different topics

This is really interesting. In a recent project, I coded each month in the drop-down list. I did not know you could simplify it this way. This is certainly useful. Keep up the great work.

great work...........

Great work....

But can anybody help me to get this months order by
like

jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec

thank you in advance

Good work! I always like to leave comments whenever I see something unusual or impressive. I think we must appreciate those who do something especial. Keep it up, thanks
Helen Olsson.

This is a more elegent approach using keywords Month/Mon you could add Week, Quarter, etc.


select to_char(add_months (trunc (sysdate,'YYYY'), 1*Level -1),'Month') as
Month,to_char(add_months (trunc (sysdate,'YYYY'), 1*Level -1),'Mon') as mon , rownum as rn FROM Dual
CONNECT BY Level <= MONTHS_BETWEEN(add_months(trunc(sysdate,'YYYY'),13), trunc(sysdate,'YYYY') + 1)
order by rn

Actually like this alot better, cleaner less SQL


select ind.l as month_ind
,to_char(add_months(trunc(sysdate,'yyyy'), ind.l-1), 'Month') as month_descr
,to_char(add_months(trunc(sysdate,'yyyy'), ind.l-1), 'Mon') as mon

from dual descr,
(select l
from (select level l
from dual
connect by level <= 12
)
) ind
order by 1;

select date between date1 and date2 in all months want help me