create table MOVIE_PLAYHIS_INFO
(
  MOVIE_PLAYHIS_ID INT IDENTITY(1,2) not null,
  START_TIME       VARCHAR(255),
  END_TIME         VARCHAR(255),
  primary key (MOVIE_PLAYHIS_ID)
);

START_TIME 格式 ‘yyyy-mm-dd hh:mi:ss’24小时制

增加2分两秒 怎么写SQL

'2012-08-14 13:00:00'   更新为 '2012-08-14 13:02:02'

create table MOVIE_PLAYHIS_INFO
(
  MOVIE_PLAYHIS_ID INT IDENTITY(1,2) not null,
  START_TIME       VARCHAR(255),
  END_TIME         VARCHAR(255),
  primary key (MOVIE_PLAYHIS_ID)
);

insert into MOVIE_PLAYHIS_INFO(START_TIME) select '2012-08-14 13:00:00'

select * from MOVIE_PLAYHIS_INFO
/*
MOVIE_PLAYHIS_ID START_TIME                     END_TIME
---------------- ------------------------------ ------------------------------
1                2012-08-14 13:00:00            NULL
*/

update MOVIE_PLAYHIS_INFO 
set START_TIME=convert(varchar(20),
dateadd(s,2,cast(START_TIME as datetime)),120)

select * from MOVIE_PLAYHIS_INFO
/*
MOVIE_PLAYHIS_ID START_TIME                     END_TIME
---------------- ------------------------------ ------------------------------
1                2012-08-14 13:00:02            NULL
*/