DECLARE @A CHAR(20) SET @A='200708011145' SELECT DATEADD(MI,RIGHT(RTRIM(@A),2)+SUBSTRING(@A,9,2)*60,LEFT(@A,8))
没错.declare @s as varchar(20) set @s = '200708011145'select cast(left(@s , 4) + '-' + substring(@s,5,2) + '-' + substring(@s,7,2) + ' ' + substring(@s , 9,2) + ':' + right(@s,2) as datetime) as time/* time ------------------------------------------------------ 2007-08-01 11:45:00.000(所影响的行数为 1 行) */
declare @t varchar(50) set @t='200708011145' set @t=substring(@t,1,8)+' '+substring(@t,8,2)+':'+substring(@t,10,2) select cast(@t as datetime) ----------------------- 2007-08-01 11:14:00.000
set @s = '200708011145'select cast(left(@s , 4) + '-' + substring(@s,5,2) + '-' + substring(@s,7,2) + ' ' + substring(@s , 9,2) + ':' + right(@s,2) as datetime)
SET @A='200708011145'
SELECT DATEADD(MI,RIGHT(RTRIM(@A),2)+SUBSTRING(@A,9,2)*60,LEFT(@A,8))
set @s = '200708011145'select cast(left(@s , 4) + '-' + substring(@s,5,2) + '-' + substring(@s,7,2) + ' ' + substring(@s , 9,2) + ':' + right(@s,2) as datetime) as time/*
time
------------------------------------------------------
2007-08-01 11:45:00.000(所影响的行数为 1 行)
*/
set @t='200708011145'
set @t=substring(@t,1,8)+' '+substring(@t,8,2)+':'+substring(@t,10,2)
select cast(@t as datetime)
-----------------------
2007-08-01 11:14:00.000