现有表如下:结构如下:
CREATE TABLE REQUESTACTIVITY
(
TIMEFROM TIMESTAMP(6) NOT NULL,
REQUESTSTATUS INTEGER NOT NULL,
)表中有如下3行数据:
TIMEFROM REQUESTSTATUS
4/12/2007 12:43:41.433000 AM 1
4/12/2007 12:44:41.433000 AM 2
4/12/2007 12:45:41.433000 AM 3现在要求把这3行数据的每一个timefrom都加1秒,变成
TIMEFROM REQUESTSTATUS
4/12/2007 12:43:42.433000 AM 1
4/12/2007 12:44:42.433000 AM 2
4/12/2007 12:45:42.433000 AM 3
请问怎么写这个update语句?
CREATE TABLE REQUESTACTIVITY
(
TIMEFROM TIMESTAMP(6) NOT NULL,
REQUESTSTATUS INTEGER NOT NULL,
)表中有如下3行数据:
TIMEFROM REQUESTSTATUS
4/12/2007 12:43:41.433000 AM 1
4/12/2007 12:44:41.433000 AM 2
4/12/2007 12:45:41.433000 AM 3现在要求把这3行数据的每一个timefrom都加1秒,变成
TIMEFROM REQUESTSTATUS
4/12/2007 12:43:42.433000 AM 1
4/12/2007 12:44:42.433000 AM 2
4/12/2007 12:45:42.433000 AM 3
请问怎么写这个update语句?
----------
DAT
---------------------------------------------------------------------------
1
27-4月 -07 01.50.49.000000 下午
SQL> update t set dat=dat + 1/(24*60*60);已更新 1 行。SQL> select * from t; ID
----------
DAT
---------------------------------------------------------------------------
1
27-4月 -07 01.50.50.000000 下午