update Otcheti set OtchetDateDt=FloatToDate(OtchetDate) GO if exists (select * from SYSTRIGGERS where LCase(trigname)=lcase('TrigOtchetiUpd')) then drop trigger TrigOtchetiUpd end if go create trigger TrigOtchetiUpd after insert,update order 1 on "DBA".Otcheti referencing new as OtchetiNew for each row begin update Otcheti set OtchetDateDt=FloatToDate(OtchetDate) where OtchetNo=OtchetiNew.OtchetNo end