>>我试过,不行!
???
CREATE TABLE [aaa] (
[a] [datetime] NULL
) ON [PRIMARY]
GO
insert into aaa values(getdate())
go
select * from aaa
go
update aaa
set a = a + convert(datetime,"00:00:01")
go
select * from aaa
go
======================
(1 row(s) affected)
a
---------------------------
2000-07-26 22:48:30.323
~~
(1 row(s) affected)
(1 row(s) affected)
a
---------------------------
2000-07-26 22:48:31.323
~~
(1 row(s) affected)
======================
可以啊
是否你的 datetime(时间) 字段不是 datetime 型的而是 varchar 型的