How to convert to number month to month name?

See more:

VB

SQL

In sql database - the data in month is in numbers (1,2,3...12). In my webpage, i would like it to display in month name (Jan, Feb, Mar....Dec). How to convert to number month to month name?

VB.Net

rs = db.ExecuteSelect("SELECT year,month, run_sequence, pay_code, qty, rate, amount, & _
convert(varchar, effective_date,103) as effective_date " & _
FROM payTable, Session("CnnStr").ToString)