請問SQL command語法 +8小時如何修改:－2016韓國代購網 , 韓國代購化妝品 , 韓國代購批發 , 韓國代購教學---韓國代購/追加/寄貨

Blogtrottr

Mobile01最新文章

Ever want to impress your boss or that special someone?

Learn the basics of wine tasting from glassware to history to tasting techniques in this online course. This is a course you're sure to enjoy!

From our sponsors

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

Nov 8th 2013, 02:48

各位高手以下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

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends:

Massacres That Matter - Part 1 - 'Responsibility To Protect' In Egypt, Libya And Syria
Massacres That Matter - Part 2 - The Media Response On Egypt, Libya And Syria
National demonstration: No attack on Syria - Saturday 31 August, 12 noon, Temple Place, London, UK

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions