Help with "Syntax error converting datetime from character string"

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Howard Carr (hjcarr_at_nf.sympatico.ca)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 13:52:10 GMT

I am gettitng the covert error with the following when I try to update the
query through my client.
The client is a Delphi app that is using ADO and the @TestDate parameter is
a datetime type.

CREATE FUNCTION EffluentDataTestByDate(@TestDate DATETIME)
RETURNS TABLE
AS RETURN
(
SELECT TestDate, Tester, AerationBasinTemp, AerationOutP, AerationOutNH3,
AerationOutN03,
.....
......
 FROM PaperMillData.dbo.EffluentData
WHERE TestDate = @TestDate

Relevant Pages