Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
Msg 8114, Level 16, State 5, Procedure InsertDataCourierReceving, Line 0
Error converting data type nvarchar to datetime.
Posted
Updated 15-Jun-11 20:36pm
Comments
Maciej Los 21-Jun-11 12:35pm    
An example, please.

It seems you're the same person who posted the same question[^]. There are answers there, have a look.
 
Share this answer
 
v2
I think this is related to the format (date format) of the string you are passing. You might need to check the culture settings of your server (DB) and the client machine (from where you have sent the date string).
This link provides you a list of different styles that can be used in date conversions in T-Sql. I also suggest to debug your code and check what string you are passing to the server, take that and convert it to date in SSMS. That would give you a better idea of your problem.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900