The conversion of SQL Server from the varchar data type to the datetime data type produces an out-of-range value.

See SQL, use DATEADD () to convert the Times title error, because the database table in the data format is incorrect, the data format is incorrect, the data format is incorrect, the important thing to say 3 times !

Ca.batch_no the first 8 bits must be date format YYYYMMDD, otherwise it will error!

When a title error occurs, first troubleshoot the SQL correctly, and then consider whether the data in the table is correct.

The conversion of SQL Server from the varchar data type to the datetime data type produces an out-of-range value.