(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.Got it ... finally!
yyyy-mm-dd
Argggggh.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment