sql - How to convert to number month to month name? -

in sql database - data in month in numbers (1,2,3...12). in webpage, display in month name (jan, feb, mar....dec). how convert number month month name?

vb.net

   rs = db.executeselect("select year,month, run_sequence, pay_code, qty, rate, amount,  " & _                                       "convert(varchar, effective_date,103) effective_date " & _                                       "from paytable id='" & id & "'", session("cnnstr").tostring) 

update : found solution.

datename(mm,dateadd(mm, month-1,0))  month 

you can use datename 3 digit month short name based on month number

declare @month int  set  @month = 1 select  left(datename( month , dateadd( month , @month , -1 )),3);