-- 季度转月度
ALTER FUNCTION [F_COMMON_QTOM_DATE_CONVERT]
(@BB_DATE AS varchar(10)  )-- 日期
RETURNS varchar(10)
AS
BEGIN
	
	--季度期别转月度期别
	
	DECLARE @QUATER VARCHAR(2);
	DECLARE @YEAR VARCHAR(4);

	SET @QUATER = SUBSTRING(@BB_DATE,5,2);
	SET @YEAR = SUBSTRING(@BB_DATE,1,4);

	IF @QUATER = '01' 
	BEGIN
			RETURN @YEAR + '-03';
	END;

	IF @QUATER = '02' 
	BEGIN
			RETURN @YEAR + '-06';
	END;

	IF @QUATER = '03' 
	BEGIN
			RETURN @YEAR + '-09';
	END;

	IF @QUATER = '04' 
	BEGIN
			RETURN @YEAR + '-12';
	END;

	RETURN NULL;

END