sql - 在SQL中将月份编号转换为月份名称功能(Convert Month Number to Month Name Function in SQL)

Question

I have months stored in SQL Server as 1,2,3,4,...12.

(我在SQL Server中以1,2,3,4，... 12的形式存储了几个月。)

I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January?

(我想将它们显示为一月，二月等。SQLServer中是否有像MonthName（1）= January这样的函数？)

I am trying to avoid a CASE statement, if possible.

(如果可能，我试图避免使用CASE语句。)

  ask by Saif Khan translate from so

Answer 1

I think this is the best way to get the month name when you have the month number

(我认为这是得到月份名称时，你有个数字的最佳方式)

Select DateName( month , DateAdd( month , @MonthNumber , 0 ) - 1 )

Or

(要么)

Select DateName( month , DateAdd( month , @MonthNumber , -1 ) )