Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    London
    Posts
    5

    Unanswered: How to enter a date parameter in Debugger

    (This is prob. a really dumb question but it's driving me mad!!...)

    I am using the Debugger in SQL Query Analyzer & want to set the value of a datetime parameter prior to executing the stored proc. The "Debug procedure" window allows me to specify the parameter values - but I can't get it to accept a datetime. The language is us_english & I've tried most ways if specifying the date - 01/02/2004, with/out quotes, 02 Jan 2004, as a full datetime, swapping day/month values etc etc. The procedure always fails immediately with: Invalid character value for cast specification.

    Thanks.

  2. #2
    Join Date
    May 2004
    Location
    London
    Posts
    5
    Got it ... finally!

    yyyy-mm-dd

    Argggggh.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •