Trying to insert a date into SQL Server 2005, with the format of 1/1/2013. This will cause the following error when running SQL Server 2005 under IIS 7.5.
Issue Details(Updated: April 4, 2013)
When inserting data into the datetime column of a SQL Server table, you must make sure that there are no invalid characters trying to be inserted; otherwise, you will experience this issue.
Microsoft OLE DB Provider for SQL Server error '80040e07' Conversion failed when converting datetime from character string. /inshape/add-ons/Equip/Inserts.asp, line 359
Recreate Issue
If you try to insert an invalid character into the datetime field, you will get this error. Using the script by CFF Coding Source, called protectSQL(), will convert the / into /
Copy
Search Site
Search Google
This script protects your database from malicious code injection.
Resolve Issue
You will need to reverse the protection done in the above Recreate to the original format. Replace the forward slash code /
Copy
Search Site
Search Google
with the actual forward slash /
Code Example
strEdate = reverseSQL(request.Form("Edate"))
What this will do is take the date: 2/19/1971 And change it to: 2/
Copy
Search Site
Search Google
19/
Copy
Search Site
Search Google
1971 This will allow it to insert into the database.