Sir, while using SQLSERVER 2008, I have these codes

UPDATE bin1 SET delay_int =
(select replace(replace(replace(CONVERT(VARCHAR(19), DATE, 120),'-',''),' ',''),':','')as int)
-(select max(replace(replace(replace(CONVERT(VARCHAR(19), DATE, 120),'-',''),' ',''),':',''))as int
   FROM bin1 j1
  WHERE j1.date < bin1.date)

but is showing this error message



and here is table structure




Actually I am converting date stamp to INT then subtract.

Please help me how to make query workable?