- SQL code
CREATE TABLE KF_SND_HISTORY ( ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ) , SENDDATE TIMESTAMP NOT NULL GENERATED ALWAYS AS (TIMESTAMP()), SDATE CHARACTER (10) GENERATED ALWAYS AS (DATE()), STIME CHARACTER (10) GENERATED ALWAYS AS (TIME()));
如上所示:创建表KF_SND_HISTORY ,有四个字段,第一个是自增ID,第二个是SENDDATE,表示当前时间,如“2010-01-11 14:36:23”,第三个字段为SDATE,表示当前日期,如“2010-01-11”,第四个字段STIME 表示当前时间,如“14:36:23”
但是如上语句建表,发现建表不成功,那应该如何写呢?
谢谢了
------解决方案--------------------------------------------------------
DB2取系统时间的函数是 current timestamp、current date、current time
不过建表时好像不能用这些函数
------解决方案--------------------------------------------------------
不能在表里面直接写,要另外写,或在插入的时候写values current timestamp