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