laravel timestamp timestampTz datetime datetimeTz 区别

测试

Schema::create('test', function (Blueprint $table) {
    $table->increments('id');
    $table->dateTimeTz('datetimetz')->comment('添加时间');
    $table->dateTime('datetime')->comment('添加时间');
    $table->timestamp('timestamp')->comment('添加时间');
    $table->timestampTz('timestampTz')->comment('添加时间');
});

打印表结构

Create Table: CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `datetimetz` datetime NOT NULL COMMENT '添加时间',
  `datetime` datetime NOT NULL COMMENT '添加时间',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 
  ON UPDATE CURRENT_TIMESTAMP COMMENT '添加时间',
  `timestampTz` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
1 row in set (0.00 sec)