CREATE TABLE tb_plat_base_info ( c_id varchar(64) NOT NULL, c_manufacturer varchar(64), c_name_chn varchar(64), c_name_en varchar(64), c_model varchar(32), c_version varchar(32), c_host_ip varchar(16), c_host_ipv6 varchar(128), i_port int4, c_process_name varchar(64), c_create_time TIMESTAMP WITH TIME ZONE, c_update_time TIMESTAMP WITH TIME ZONE, CONSTRAINT pk_plat_base_info PRIMARY KEY (c_id) );
c_create_time TIMESTAMP WITH TIME ZONE,
或
c_create_time timestamptz (6),
生成的时间带有时区的 2018-10-25 14:36:00.096+08
CREATE TABLE tb_plat_base_info ( c_id varchar(64) NOT NULL, c_manufacturer varchar(64), c_name_chn varchar(64), c_name_en varchar(64), c_model varchar(32), c_version varchar(32), c_host_ip varchar(16), c_host_ipv6 varchar(128), i_port int4, c_process_name varchar(64), c_create_time timestamp(6), c_update_time timestamp(6), CONSTRAINT pk_plat_base_info PRIMARY KEY (c_id) );
c_create_time timestamp(6) 生成的时间是2018-10-25 14:36:00.096
