Geeks With Blogs
Baskar B.V SQL - BI Consultant February 2009 Entries
Converting short month name strings to full month name
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(varc... mth_shrt_nm + '/1900',121)) from table1 ......

Posted On Thursday, February 26, 2009 11:06 AM

Copyright © Baskar B.V | Powered by: