sql - 如何在sql server 2008中创建时+分+秒的时间

Question

我有三个 var char 值作为

@hour = '18'
@minute = '25'
@seconds = '45'

我需要'18:25:45'形式的输出

Select from Convert(Time,@hour+@minute+@seconds)

来自 SSRS 报告下拉列表的时分秒值

Answer 1

您可以从零开始“累加”值，如下所示:

declare @hour smallint = 18
declare @minute smallint = 25
declare @seconds smallint = 45
declare @result time

SELECT @result =  DATEADD(hour, @hour, DATEADD(minute, @minute, DATEADD(second, @seconds, 0)))