Problem with date parameter in stored procedure

[KaizerV3]

Hello,

I made a stored procedure where u have to give the date in a paramater and then the result should come. But somehow it doesnt work.

It works likes this:

CREATE PROCEDURE [dbo].[spG_NeoTestDatesSerge]

AS


SELECT TestID
FROM dbo.Test
WHERE (DefinitionID = 7) AND (CONVERT(char(10), EndDate, 103) = '19/03/2007')
GO


When I test this , I get the result from testid.

Now when I put a variable in like this:

CREATE PROCEDURE [dbo].[spG_NeoTestDatesSerge]

@Datum varchar

AS


SELECT TestID
FROM dbo.Test
WHERE (DefinitionID = 7) AND (CONVERT(char(10), EndDate, 103) = @Datum)
GO


It doesnt work ! I dont get any results. I would give '19/03/2007' as paramater but it doesnt work.

Anyone has a clue ? Or a solution ?

thanks in advance

[iburyak]

Did you try to change

[PHP]
@Datum varchar[/PHP]

to

[PHP]
@Datum varchar(10)[/PHP]

[KaizerV3]

Thank you my friend !

You have helped me alot !!