SQL:UserDefinedFunction:Quarter

出自ProgWiki

用途

• 仿 Quarter()

程式碼

-- 物件:  UserDefinedFunction [dbo].[Quarter]
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
go
 
CREATE FUNCTION [dbo].[Quarter]
(
	@d AS DATETIME 
)
RETURNS INT
AS
BEGIN
	DECLARE @ResultVar AS INT
	DECLARE @mm AS INT
 
	SET @mm = MONTH(@d)
 
	SET @ResultVar = CASE
		WHEN @mm in (1,2,3) THEN 1
		WHEN @mm in (4,5,6) THEN 2
		WHEN @mm in (7,8,9) THEN 3
		WHEN @mm in (10,11,12) THEN 4
	END 
 
	-- Return the result of the function
	RETURN @ResultVar
END