what's wrong with just using the datename function ?

i.e. select datename(mm,getdate()) --retuns a value of January

and then if you just want the 1st 3 letters add a left to the command

select left(datename(mm,getdate()),3) --retuns a value of Jan