亲爱的先生/女士 如何在单一选择查询中将浮点数转换为时间戳 <对于exp,。我有浮动为1.251152515236, i希望将此转换为日期时间并从datetime转换为时间戳...即02:22:044456 我需要sql查询 它实际上是用xml制作的.crd文件,我有查询在xml里面像
Dear Sir/Madam how to convert float to timestamp in single select query for exp. i have float as 1.251152515236 , i want to convert this to datetime and from datetime to timestamp... i.e. 02:22:044456 I need sql query It is actually .crd file made in xml , and i have query inside xml like
<![CDATA[ SELECT USER.LastName, USER.fltime from Tbalname ]>fltime有浮点数据类型值我需要转换为时间 问候 Maulik Shah
fltime has float datatype value which i need to convert to time Regards Maulik Shah
推荐答案简单示例: Simple example: declare @timeMoment float set @timeMoment = 1.251152515236 select @timeMoment as floatValue, cast(@timeMoment as DateTime) as datetimeValue
结果:
Result:
floatValue datetimeValue 1.251152515236 1900-01-02 06:01:39.577更顺畅:
More smooth:
declare @timeMoment float declare @datetimeValue datetime set @timeMoment = 1.251152515236 set @datetimeValue = cast(@timeMoment as DateTime) select Right('00' + Cast(DATEPART(hh, @datetimeValue) as varchar(2)), 2) + ':'+ Right('00' + Cast(DatePart(mi, @datetimeValue) as varchar(2)), 2) + ':'+ Right('00' + Cast(DatePart(ss, @datetimeValue) as varchar(2)), 2) + '.'+ Cast(DatePart(ms, @datetimeValue) as varchar)在SQL Server中长SELECT Right ..... ca也可以更改为:
in SQL Server the long SELECT Right..... ca also be changed to:
select cast(@datetimevalue as time) test
更多推荐
如何在单选择查询中将float转换为时间戳(SQL)
发布评论