将varchar数据类型转换为datetime数据类型时导致了超出范围的值。
select a.DLNO,
a.NAME,
b.TOPSTRING,
Convert(datetime,a.DOB,103) as DOB,
Convert(datetime,a.DOI,103) as DOI,
Convert(datetime,b.datepushed,103) as datepushed
from
PLInfo_Demo a,DLInfo_Demo b
where
a.dlno=b.DLNO