22,210
社区成员
发帖
与我相关
我的任务
分享
DECLARE @abc table(sktime char(5))
INSERT INTO @abc
SELECT '0:16' UNION ALL
SELECT '11:16' UNION ALL
SELECT '16:40' UNION ALL
SELECT '21:30' UNION ALL
SELECT '23:05'
UPDATE @abc
SET sktime = RIGHT('0'+CONVERT(varchar(2),
(CONVERT(int,
LEFT(sktime,CHARINDEX(':',sktime)-1)
)+2) % 24
),
2) + SUBSTRING(sktime,CHARINDEX(':',sktime),3)
SELECT * FROM @abc
sktime
------
02:16
13:16
18:40
23:30
01:05
DECLARE @table1 table(sktime char(5))
INSERT INTO @abc
SELECT '11:16' UNION ALL
SELECT '16:40' UNION ALL
SELECT '21:30' UNION ALL
SELECT '23:05'
UPDATE @abc
SET sktime = RIGHT('0'+CONVERT(varchar(2),
(CONVERT(int, LEFT(sktime,2))+2) % 24
),
2) + RIGHT(sktime,3)
SELECT * FROM @abc
sktime
------
13:16
18:40
23:30
01:05
create table abc(sktime time)
insert into abc(sktime)
select '11:16' union all
select '12:13' union all
select '23:44'
select * from abc
/*
sktime
----------------
11:16:00.0000000
12:13:00.0000000
23:44:00.0000000
(3 row(s) affected)
*/
-- 时间加2小时
update abc set sktime=dateadd(hh,2,sktime)
select * from abc
/*
sktime
----------------
13:16:00.0000000
14:13:00.0000000
01:44:00.0000000
(3 row(s) affected)
*/