如何在单选择查询中将float转换为时间戳（SQL）

本文介绍了如何在单选择查询中将float转换为时间戳（SQL）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

亲爱的先生/女士 如何在单一选择查询中将浮点数转换为时间戳 <对于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