New answers tagged

2

See https://github.com/mj1856/SqlServerTimeZoneSupport by Matt Johnson for Sql Server 2008R2+.


0

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