Answers for "update datetime in sql on insert/update"

insert date sql

INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));

Posted by: Guest on June-29-2020

automatically update database last seen datetime in sql

ALTER TABLE  `test_time` ADD  `dt` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP

Posted by: Guest on January-03-2021

Code answers related to "update datetime in sql on insert/update"