MySQL时间偏移量_MySql搜索时间戳基于时区偏移量

我创建了一个样本表,其方案与原始方案相同.

数据库“test”中的表名“记录”

数据库时区设置为UTC

(SET time_zone =“00:00”;)

`records` (`id`, `name`, `time_created`)

(1, 'motion', '2017-09-13 16:20:41'),

(2, 'motion', '2017-09-13 16:20:57'),

(3, 'motion', '2017-09-13 16:21:24'),

(4, 'motion', '2017-09-13 16:21:40'),

(5, 'motion', '2017-09-13 16:26:38'),

(6, 'motion', '2017-09-13 17:09:00'),

(7, 'motion', '2017-09-13 17:09:16'),

(8, 'motion', '2017-09-13 22:14:37'),

(9, 'motion', '2017-09-13 22:23:53'),

(10, 'motion', '2017-09-13 22:24:08'),

(11, 'motion', '2017-09-13 22:24:24'),

(12, 'motion', '2017-09-13 23:45:17'),

(13, &