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