Pourquoi cela ne marche pas

ALTER FUNCTION dbo.FnCalculRepas
( @DEBUT DATETIME, @FIN DATETIME)

RETURNS INT
AS
BEGIN
DECLARE @ret tinyint
IF DATEDIFF(hh, @DEBUT, @FIN) > 0
SET @ret = 0
ELSE
SET @ret = 1

RETURN @ret

END

DECLARE @d1 DATETIME
DECLARE @d2 DATETIME
SET @d1 = '20050202 21:50'
SET @d2 = '20050202 21:00'
SELECT dbo.FnCalculRepas(@d1,@d2)
select DATEDIFF(hh, @d1, @d2)


br

"CASoft" <fr.delesse@wanadoo.fr> wrote in message
news:OvKWmWSDFHA.3648@TK2MSFTNGP10.phx.gbl...

ALTER FUNCTION dbo.FnCalculRepas
( @DEBUT DATETIME, @FIN DATETIME)

RETURNS INT
AS
BEGIN
IF CAST(DATEDIFF(hh, @DEBUT, @FIN) AS INT) > 0
RETURN 0
ELSE
RETURN 1
END

merci pour votre aide