To get previous month names

[boreddy]

How can i get last there previous month names by useing system date

[krishnaindia2007]

Select to_char(add_months(sysdate,-rownum),'month') prev_months from user_tables where rownum<=3;

[debasisdas]

Select to_char(add_months(sysdate,-rownum),'month') prev_months from user_tables where rownum<=3;

Will that work in SQL server ?

[krishnaindia2007]

Will that work in SQL server ?

Sorry. I answered the question without observing forum.

[boreddy]

I got the answer for question


select datename(month, dateadd("month",-1,getdate())), datename(month, dateadd("month",-2,getdate())),
datename(month, dateadd("month",-3,getdate()))

[nageshkota]

Sorry boreddy u cant use month is quotes.

Use
select datename(month, dateadd(month,-1,getdate())), datename(month,
dateadd(month,-2,getdate())),datename(month, dateadd(month,-3,getdate()))