a table 1 field is varchar I want to insert into table2 datetime
example
Table 1 Col1 = 2016-06-20 00: 00: 00.000
when inserting the system shows me the following message:
Msg 242, Level 16, State 3, Procedure Bdi_Insert_BDI_Absence1, Line 9
The conversion of a nvarchar data in datetime data type created a value out of range.
The statement has been terminated.