update datetime in sql on insert/update code example
Example 1: insert date sql
INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));
Example 2: automatically update database last seen datetime in sql
ALTER TABLE `test_time` ADD `dt` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP