Madsing
asked on
Execute Stored Procedure with date variable
Hello Folks,
I have created a Stored Procedure in MS Management Studio in a MS SQL Server 2008. The SP required a input parameter called @InputDate.
The input date is defined as:
@InputDate as datetime = '1753-01-01 00:00:000'
When I right-click the SP and click Execute Stored Procedure Studio Management gives me:
When I click OK it gives me the following error message:
Msg 8114, Level 16, State 5, Procedure CustomerWebServiceGetByDat e, Line 0
Error converting data type nvarchar to datetime.
(1 row(s) affected)
So I know that I don't parse the correct value.
Can somebody please help me with the correct value to parse?
I have created a Stored Procedure in MS Management Studio in a MS SQL Server 2008. The SP required a input parameter called @InputDate.
The input date is defined as:
@InputDate as datetime = '1753-01-01 00:00:000'
When I right-click the SP and click Execute Stored Procedure Studio Management gives me:
When I click OK it gives me the following error message:
Msg 8114, Level 16, State 5, Procedure CustomerWebServiceGetByDat
Error converting data type nvarchar to datetime.
(1 row(s) affected)
So I know that I don't parse the correct value.
Can somebody please help me with the correct value to parse?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a bunch!