create SEQUENCE ftpapp.LINKAGE_SEQ AS INTEGER MINVALUE 1 MAXVALUE 2147483647
START WITH 1 INCREMENT BY 1
CACHE 20 NO CYCLE NO ORDER;
--设置自增序列从20001开始
ALTER SEQUENCE LINKAGE_SEQ RESTART WITH 20001;
使用自增字段 插入一条数据
INSERT INTO LINKAGE VALUES (NEXT VALUE FOR LINKAGE_SEQ,current date,'account1','sub1','0');
修改列类型
ALTER TABLE db2admin.ftp_adjust_definition ALTER COLUMN start_date SET DATA TYPE timestamp;
ALTER TABLE db2admin.ftp_adjust_definition ALTER COLUMN update_date SET DATA TYPE timestamp;
年月日 时分秒的显示
to_char(far.start_date,'yyyy-MM-dd hh24:mi:ss'),
timestamp类型 的数据是 current timestamp
CREATE TABLE db2admin.aaaaa (
start_date timestamp,
update_date timestamp
) ;
select * from AAAAA;
insert into AAAAA values(current timestamp,current timestamp);
(select current timestamp from SYSIBM.SYSDUMMY1)