如何将秒转换为小时秒 [英] How to convert seconds to hours mintues seconds

问题描述

我有两列名为秒和时间。我有秒记录存储在秒列中。我希望代码转换并在时间列中将秒显示为hh：mm：ss，请提供代码帮助我。



我尝试过：



i创建了两列（秒和时间），并在秒列中输入了所有记录。

I have two columns named "seconds" and "time". I have seconds records stored in "seconds column". i want the code to convert and display the seconds into hh:mm:ss in the "time column", kindly help me by providing the code.

What I have tried:

i have created two columns(seconds and time) and have entered all the records in "seconds" column.

推荐答案

如果是SQL Server，请尝试以下操作 -

If it is SQL Server, try following-

SELECT CONVERT(time(0), DATEADD(SECOND, [seconds], 0)) as [time]

示例：

Example:

DECLARE @seconds INT
SELECT CONVERT(time(0), DATEADD(SECOND, @seconds, 0)) as [time]

希望，它有帮助：）

Hope, it helps :)

这篇关于如何将秒转换为小时秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！