請問SQL command語法 +8小時如何修改

各位高手以下Command要加上8小時計算秒數

請問該如何修改以下指令?

謝謝!


declare @Start_Date
datetime, @End_Date
datetime, @Days
int , @Total_Mins
int, @CDR_Table
Varchar(20), @in_tg
Varchar(30), @Query
varchar(500) /* 設定區 */
set @Start_Date = '20131105'
set @End_Date = '20131105'
set @in_tg = ' ''388%'' '
set @Days= (datepart(day,@End_Date)) - (datepart(day,@Start_Date)) + 1 while (@Days > 0)
BEGIN
set @Days = @Days - 1
set @CDR_Table = 'dbo.cdr'+(convert(varchar(8),dateadd(day,-@Days,@End_Date),112))
set @Query = 'select datepart(day,connect_time) ,count(*),sum(talk_dur/60) from ' + @CDR_Table + ' where in_tg like' + @in_tg + 'group by datepart(day,connect_time)' exec ( @Query)
END