在线等，高手进

[jikuiyu]

20110929102725
这是一个float型，如何转成日期

[-晴天]

declare @dt float
set @dt= 20110929102725
select convert(datetime,stuff(stuff(stuff(convert(varchar(20),convert(decimal(16,0),@dt)),9,0,' '),12,0,':'),15,0,':'))
/*
-----------------------
2011-09-29 10:27:25.000

(1 行受影响)

*/

[geniuswjt]

declare @n float=20110929102725,@m varchar(20),@t varchar(20)
set @m=convert(varchar(20),convert(bigint,@n))
set @t=dateadd(hh,convert(int,SUBSTRING(@m,9,2)),LEFT(@m,8))
set @t=dateadd(mi,convert(int,SUBSTRING(@m,11,2)),@t)
set @t=dateadd(ss,convert(int,SUBSTRING(@m,13,2)),@t)
select convert(varchar(20),convert(datetime,@t),120)

/*

--------------------
2011-09-29 10:27:00

(1 行受影响)