Forum Discussion

raultellez17's avatar
raultellez17
Frequent Visitor
9 years ago

How to add an IN PARAMETER Type TimeStamps in Stored Procedures calls?

I'm having problems calling a stored procedures from script, the error ocurred exactly when I try to add an in parameter type DBtimestamp.   this is the code: var SProc; SProc = ADO.CreateADOSt...
Marsha_R's avatar
Marsha_R
Moderator

What error did you get?  The exact message will help us help you.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago

The error message would help, for sure... but question: You are apparently assigning a full date and time to the parameter. Shouldn't you be using adDBTimeStamp instead? I'm not sure if that would cause your error, but it seems odd to be using a time only datatype when you are passing in a full date time