處理時(shí)間時(shí)用到了，記錄一下。

時(shí)間差天數(shù)

select ‘2017-12-10’::date – ‘2017-12-01’::date;

時(shí)間差秒數(shù)

select extract(epoch FROM (now() – (now()-interval ‘1 day’) ));
select trunc(extract(epoch FROM (now() – (now()-interval ‘1 day’) ))::numeric);
select trunc(extract(epoch FROM (now() – (now()-interval ‘1 day’) ))::numeric,1);
select round(extract(epoch FROM (now() – (now()-interval ‘1 day’) ))::numeric);
select round(extract(epoch FROM (now() – (now()-interval ‘1 day’) ))::numeric,1);