DateTime _Oct2007

[r a j u u]

hi.... Now displaying date like 10-2007 but I want to display Oct-2007.in Sql Query..anybody know plz reply me..

Rajendran

[soni uma]

Try This, select convert(varchar(50),getdate(),106) :)

[r a j u u]

hi soni Uma....Thanks for reply..... I want to display only the month and year..(Oct-2007) if u know that plz reply me.. see the following code...thats i have used...but its displaying 10-2007.... select Cast(DatePart(month,RenewalBaseMonth) as varchar) + '/' +Cast(DatePart(year,RenewalBaseMonth) as varchar) as RenewalBaseMonth from #temp21 Thanks

Rajendran

[Senu Gandhi]

Hi, Try this select Cast(DateName(month,RenewalBaseMonth) as varchar(3)) + '/' +Cast(DatePart(year,RenewalBaseMonth) as varchar) as RenewalBaseMonth from #temp21 Senthil -- modified at 8:15 Tuesday 30th October, 2007

[soni uma]

Ok This is work fine select DATENAME(MONTH,GETDATE()) + '/' + Cast(DatePart(year,getdate()) as varchar):) Have nice time

[r a j u u]

hi, Its working fine.... Really good work and thanks alot....

Rajendran

[Senu Gandhi]

Pls rate my answer if it is working well Senthil

[r a j u u]

Thanks for reply...already senu gandhi sent me that solution...I solved that problem ... Thanks..

Rajendran

[r a j u u]

May I know where u r working..If u feel good tell me. Thanks..

Rajendran

[Andy M]

Senu Gandhi wrote:

Pls rate my answer if it is working well

It is rude to solicit votes.

[Senu Gandhi]

Hi Rajendran, I am working in Pricol Ltd, Coimbatore as Dev lead. How about u? Senthil

[Senu Gandhi]

I am sorry Andy. Senthil