如何在单选择查询中将float转换为时间戳（SQL） [英] how to convert float to timestamp in single select query (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 

这篇关于如何在单选择查询中将float转换为时间戳（SQL）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！