18-10-12, 07:27 AM
كاتب الموضوع : Boutemine Oualid
السلام عليكم و رحمة الله و بركاتهكود :
CREATE FUNCTION IsLeapYear (@Annee AS int)
RETURNS bit
AS
BEGIN
Declare @Date29Fev AS Datetime
Declare @Result AS bit
SET @Date29Fev = DATEADD(DAY, -1, Cast('01/03/'+Cast(@Annee AS varchar(4)) AS datetime))
IF Day(@Date29Fev )=29
SET @Result =1
ELSE
SET @Result = 0
return @Result
END