在Postgresql上,我想取得兩個時間的差值（以秒為單位），方法如下：

??????? SELECT a.*, Extract( epoch from (a.start_time - '#ivr_start#')) as? gap

??????? FROM ivr_detail_log a??
??????? WHERE callerid = '#callerid#'
??????? AND
??????? abs(Extract( epoch from (a.start_time - '#ivr_start#')))<20

??????? ORDER BY id
???????????




|----------------------------------------------------------------------------------------|
                           版權(quán)聲明  版權(quán)所有 @zhyiwww
            引用請注明來源 http://www.aygfsteel.com/zhyiwww   
|----------------------------------------------------------------------------------------|