DROP TRIGGER "main"."trg_udate"; CREATE TRIGGER "main"."trg_udate" AFTER UPDATE ON "tbl_test" BEGIN UPDATE tbl_test set udate = datetime('now','localtime') where id = old.id ; END;