Saya Punya potongan query seperti ini :

CREATE TABLE #DATE (NIP CHAR (50), NAMA VARCHAR (512), TGLAHIR DATETIME, BTSPENSIUN INT, TGPENSIUN_OLD CHAR (10), TGPENSIUN DATETIME)



INSERT INTO #DATE (NIP, NAMA, TGLAHIR, BTSPENSIUN, TGPENSIUN_OLD,TGPENSIUN)

SELECT NIP,NAMA,TGLAHIR,BTSPENSIUN,TGPENSIUN,NULL

FROM #DATE01



UPDATE #DATE SET TGPENSIUN = CASE WHEN ISDATE(TGPENSIUN_OLD) = 1 and TGPENSIUN_OLD LIKE '%-%'

THEN CONVERT(DATETIME, TGPENSIUN_OLD, 103) ELSE

CONVERT(DATETIME, TGPENSIUN_OLD, 103) END 



SELECT * FROM #DATE 

Ketika di execute, saya ,mendapatkan pesan
"Msg 242, Level 16, State 3, Line 338
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."



Mohon solusinya Agan2 dan Agan Wati