Conversion failed when converting date and/or time from character string.

Question

1.00/5 (1 vote)

See more:

Hi all,

I am inserting data through Stored Procedure into database by sending xml. I got this exception. is there any solution for this.

Thank you All.

Posted 12-Sep-13 23:14pm

Sivarjun Chikkala

Add a Solution

Comments

[no name] 13-Sep-13 5:14am

Share your code..else it's not possible to tell the solution..

lukeer 13-Sep-13 5:23am

What does the relevant portion of the string look like?
What date/time is it representing?

[no name] 13-Sep-13 7:30am

Does not matter what your code is. The error message is perfectly clear. The solution is to supply a datetime in the format that you are expecting.

1 solution

Add a Solution

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

ZurdoDev · Answer 1 · 2013-09-13T01:42:00

Solution 1

The solution is to make sure your data is correct. The error is saying that you are trying to put something into a date field that is not a date. For example, perhaps you are trying to put a blank into a date field. You can't do that. You'll need to insert NULL instead.

Posted 13-Sep-13 1:42am

ZurdoDev

Conversion failed when converting date and/or time from character string.

1 solution

Solution 1

Add your solution here

Preview 0

Conversion failed when converting date and/or time from character string.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us