1SET @old_log_timestamps = @@global.log_timestamps; 2SET GLOBAL log_timestamps=UTC; 3SELECT @@global.log_timestamps; 4@@global.log_timestamps 5UTC 6SET GLOBAL log_timestamps=SYSTEM; 7SELECT @@global.log_timestamps; 8@@global.log_timestamps 9SYSTEM 10SET SESSION log_timestamps=UTC; 11ERROR HY000: Variable 'log_timestamps' is a GLOBAL variable and should be set with SET GLOBAL 12SET GLOBAL log_timestamps=ON; 13ERROR 42000: Variable 'log_timestamps' can't be set to the value of 'ON' 14SET GLOBAL log_timestamps=2; 15ERROR 42000: Variable 'log_timestamps' can't be set to the value of '2' 16SET GLOBAL log_timestamps=DEFAULT; 17SELECT @@global.log_timestamps; 18@@global.log_timestamps 19UTC 20SET GLOBAL log_timestamps = @old_log_timestamps; 21