[dba-SQLServer]Convert int month to char month

I don't think SQL SErver has a FORMAT function. I checked some of the codes
and I couldn't find one that returns the abbreviated month as text --

Susan H.


> try something like
>
> format(MyIntNumber,"MMM")
>
> that may do it.....
>
> Paul
> Does anyone know of a way to convert the return value of month([mydate])
from an integer to its equivalent char value?
>
> 1 JAN
> 2 FEB
> 3 MAR