SQL中将月份数字转换为月份名称函数

2022-01-30 00:00:00 sql sql-server-2005 tsql sql-server

我在 SQL Server 中存储的月份为 1、2、3、4、...12.我想将它们显示为一月、二月等.SQL Server 中是否有像 MonthName(1) = 一月这样的函数?如果可能，我会尽量避免使用 CASE 语句.

I have months stored in SQL Server as 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? I am trying to avoid a CASE statement, if possible.

推荐答案

当你有月份编号时，我认为这是获取月份名称的最佳方式/p>

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 )

或者

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

相关文章