劍道第一仙

select (extract(epoch from cast(t.pgtime as timestamp))-extract(epoch from cast(t.inserttime as timestamp)))/60 as ddd 
from table_base t  -- 實體表
where (extract(epoch from cast(t.pgtime as timestamp))-extract(epoch from cast(t.inserttime as timestamp)))/60 > 120 -- pgtime大于inserttime 120分鐘
limit 100;