>>Why not use DATEDIFF() ?
>
>Sir DATEDIFF() will not work with this line of code
>
>

>WHERE j1.date < bin1.date)
>

Really?!?

UPDATE bin1 SET delay_int = DATEDIFF(ms,  (select max(j1."date") FROM bin1 j1 WHERE j1.date < bin1.date), "date" )

MartinaJ