[Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification - SQLSTATE: 22005

This will normally happen when table in the database is expecting one type and the application is inserting data of another type.In our case the type of column in database is of DateTime type and the application is inserting numeric data into it.
Note that even the direct execution of the query in SQL server Management Studio will throw a similar error.Now check whether the application is passing the wrong type or the table is created with wrong type.