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:

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
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 sdfgdf2 的頭像
    sdfgdf2

    中文名字日文翻譯, 中文翻譯日文名字, 名字日文翻譯, 日文翻譯名字, 日文翻譯字典發音, 日文翻譯網 漢字,

    sdfgdf2 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄