Ms SQL Server Returns 12 months

If you use the DATENAME () function to obtain the full name of a month, you only need to display the abbreviated name of a month.

The abbreviation of the 12 months is the same as that of the month in August. The abbreviation of other months is only the first three letters. Therefore, Insus. NET writes a UDF:
Copy codeThe Code is 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