Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

To get previous month names

This is a discussion on To get previous month names within the SQL Server forums, part of the Databases category; How can i get last there previous month names by useing system date...

Geeks Talk > Databases > SQL Server To get previous month names

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   04-01-2008

boreddy Junior Member   Join Date: Mar 2008 Location: hyderabad Posts: 11 Thanks: 0 Thanked 1 Time in 1 Post

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

Sponsored Links

#2 (permalink)   04-01-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 64 Times in 63 Posts

Re: To get previous month names Select to_char(add_months(sysdate,-rownum),'month') prev_months from user_tables where rownum<=3;

#3 (permalink)   04-01-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 126 Times in 113 Posts

Re: To get previous month names Quote: Originally Posted by krishnaindia2007 Select to_char(add_months(sysdate,-rownum),'month') prev_months from user_tables where rownum<=3; Will that work in SQL server ?

#4 (permalink)   04-02-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 64 Times in 63 Posts

Re: To get previous month names Quote: Originally Posted by debasisdas Will that work in SQL server ? Sorry. I answered the question without observing forum.

#5 (permalink)   04-03-2008

boreddy Junior Member   Join Date: Mar 2008 Location: hyderabad Posts: 11 Thanks: 0 Thanked 1 Time in 1 Post

Re: To get previous month names 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()))

#6 (permalink)   09-18-2008

nageshkota Junior Member   Join Date: Apr 2008 Location: Hyderabad Posts: 28 Thanks: 1 Thanked 4 Times in 2 Posts

Re: To get previous month names 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()))

Geeks Talk > Databases > SQL Server

« How can we delete the duplicate data from a database table? | update to null value column »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
To read the previous record from the last	farhana	MainFrame	0	12-13-2007 02:51 AM
Find previous executed SQL	pande.dhiraj	SQL	3	11-20-2007 04:16 AM
I want to get the previous row from a table	divya_rad	SQL	7	07-25-2007 03:56 AM
Latest and previous versions of LR, Winrunner and QC	karthik.dr	WinRunner	0	06-06-2007 12:51 AM
find current and previous profession...	psuresh1982	Brainteasers	21	01-08-2007 05:55 AM

All times are GMT -4. The time now is 12:21 PM.