34,590
社区成员
发帖
与我相关
我的任务
分享
select convert(varchar(8),cast('0:0:01' as datetime),8) FROM tb
select convert(varchar(8),cast('0:0:01' as datetime),108) FROM tb
select convert(varchar(8),cast('0:0:01' as datetime),114 ) FROM tb
select convert(varchar(8),cast('0:0:01' as datetime),14 ) FROM tb
--sql2000
select convert(varchar(8),cast('0:0:01' as datetime),108) FROM tb
/**
--------
00:00:01
(1 行受影响)
**/
RIGHT(CONVERT(varchar(20), CONVERT(datetime,
CONVERT(varchar(10), GETDATE(), 120) + ' ' + TelTimeLong), 120), 8)
select cast('0:0:01' as time) FROM tb
create table tb(times varchar(10))
insert tb select '0:0:01'
select * from tb
/*
times
0:0:01
*/
select left(convert(time,times),8) FROM tb
/*
(无列名)
00:00:01
*/
drop table tb
select left(convert(time,'0:0:01'),8)
select convert(time,'0:0:01')