Geeks With Blogs
Baskar B.V SQL - BI Consultant

The below query would help if want to convert short month string (e.g) Jan, Feb to full month string (e.g) January, February...

Assuming mth_shrt in table1 has value like Jan, Feb, Mar and after the execution of the below query the result would be

 

Result:

January

February

Hope this helps. Post your views on this.

select datename(month,convert(varchar(20),'01/'+ mth_shrt_nm + '/1900',121)) from table1 Posted on Thursday, February 26, 2009 11:06 AM | Back to top


Comments on this post: Converting short month name strings to full month name

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Baskar B.V | Powered by: GeeksWithBlogs.net