Dates as Input Parameters

[cfriedberg]

I know this must be simple but I have yet to figure it out.

What does the input parameter have to look like for a DateTime variable?

I have a very simple test:
Create PROCEDURE DateTest @MyDate DateTime
AS
Select @MyDate

By going to the Debug feature in the Query Analyzer and typing '01/01/2002', I get the following error message:

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

I need to know just what to enter in the Sproc as well as the input variable.

Thank you,

Carolyn

 

[SQLSister]

I ran your test procedure and it worked fine for me when I executed it. I typed:

Exec DateTest '01/01/2002'

Only thing I could think of is maybe you accidentally typed a letter O instead of a zero?

 

[cfriedberg]

SQLSister,

You are right. It works from the Query Analyzer command line. However, it does not work if I try to use the Debug feature by typing in the date.

Thank you for your response.

Carolyn

 

[jmaddone]

In 8.0, if you use the YYYY-MM-DD format, it should let you debug using a date input.