-- =============================================
-- 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