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?