Passing a smalldatetime parameter in the debugger

• Xavier Castillo

  Old Hand

  Points: 391

  More actions

  September 8, 2005 at 12:01 pm

  #87627

  I have created the following SQL Server stored procedure:

  CREATE PROCEDURE dbo.cp_proc1

    (@birthDate smalldatetime)

     AS ....

  How do pass the "smalldatetime" parameter when debugging this procedure?

  I get this error: "Invalid character for cast specification". It's a syntax error when passing the parameter.

  Thanks in advance,

  Xavier Castillo

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 8, 2005 at 12:08 pm

  #588495

  What do you enter?

• Xavier Castillo

  Old Hand

  Points: 391

  More actions

  September 8, 2005 at 10:09 pm

  #588614

  I enter '09/01/1999', for example.  This means Sep/1st/1999.

  Thanks.

• Tom Mohoric

  SSC Enthusiast

  Points: 169

  More actions

  September 9, 2005 at 4:41 am

  #588660

  Try 1999-09-01 00:00:00.

• Xavier Castillo

  Old Hand

  Points: 391

  More actions

  September 9, 2005 at 10:43 am

  #588796

  That worked fine.

  Thank you.