New answers tagged


See by Matt Johnson for Sql Server 2008R2+.


My solution is with a trigger: DELIMITER // CREATE TRIGGER `update_to_utc` BEFORE INSERT ON `my_table` FOR EACH ROW BEGIN set new.my_field=utc_timestamp(); END// DELIMITER ; Then every new inserted row will have the timestamp in UTC.

Top 50 recent answers are included