MS SQL Server gets 12-month English abbreviations _mssql

If you use the Datename () function to get the full English name of the month, but the report needs it, just display the month name abbreviation.

The 12-month abbreviation, only May is the full name and abbreviation, the other month abbreviation is only takes the first three characters. So Insus.net writes a custom function:

Copy Code code as follows:

-- =============================================
--Author:Insus.NET
--Create date:2012-12-18
--description:get Month abbreviation name
-- =============================================
CREATE FUNCTION [dbo]. [Udf_monthshortname]
(
@input DATETIME
)
RETURNS NVARCHAR (3)
As
BEGIN
DECLARE @rtn NVARCHAR (3)
SET @rtn = SUBSTRING (Datename (MONTH, @input), 1, 3)
Return @rtn
End