如何将秒转换为小时秒

本文介绍了如何将秒转换为小时秒的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有两列名为秒和时间。我有秒记录存储在秒列中。我希望代码转换并在时间列中将秒显示为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 :)