db2设置修改TIMESTAMP字段默认值为系统当前时间

 

创建表时设置

CREATE TABLE testtime(
    id VARCHAR(100) NOT NULL,
    addtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

 

修改

ALTER TABLE testtime ALTER COLUMN addtime SET WITH DEFAULT CURRENT_TIMESTAMP ;

 

查询系统当前时间

select CURRENT_TIMESTAMP from sysibm.dual; 
select CURRENT TIMESTAMP from sysibm.dual;