Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Transact SQL Debugger

Author  Topic 

corja
Starting Member

1 Post

Posted - 2005-08-30 : 12:46:00
Im trying to use the SQL Analyser Debugger but, when I pass the parameters the program returns the follow message: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification.
This problem occurs when I pass a parameter with smalldatetime datatype. I dont know how is the correct form to pass the date('08/30/2008', 08/30/2005, ...)
Somebody help me!! :)

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-08-30 : 13:48:34
try yyyymmdd format

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -