C11/System/ARI/SQL/schema/Kalender/functions/kalender.quarter_name.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE FUNCTION [kalender].[quarter_name] (@Datum AS DATE)
RETURNS VARCHAR(30)
AS 

BEGIN
   RETURN convert(varchar, datepart(qq, @Datum)) + '. Q. ' + convert(varchar, year(@Datum))
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO