PostgreSQL 时间函数的比较

发布时间：2020-12-13 17:21:22 所属栏目：百科来源：网络整理

导读：写一个function来测试比较： do $$ declare begin for i in 1.. 20 loop raise notice 'time1:%,time2:%,time3:%,time4:%',localtimestamp,current_timestamp,now(),clock_timestamp() ; end loop; end; $$; postgres=# dopostgres-# $$postgres$# declarepo

写一个function来测试比较：

$$
declare
begin
for i in 1.. 20 loop
raise notice 'time1:%,time2:%,time3:%,time4:%',localtimestamp,current_timestamp,now(),clock_timestamp() ;
end loop;
end;
$$;

postgres=# do
postgres-# $$
postgres$# declare
postgres$# begin
postgres$# for i in 1.. 20 loop
postgres$# raise notice 'time1:%,clock_timestamp() ;
postgres$# end loop; 
postgres$# end;
postgres$# $$;
NOTICE:  time1:2015-03-11 09:00:00.440075,time2:2015-03-11 09:00:00.440075+08,time3:2015-03-11 09:00:00.440075+08,time4:2015-03-11 09:00:00.442224+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442269+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442291+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442311+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442336+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442356+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442376+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442395+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442416+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442833+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442881+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442906+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442926+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442945+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442965+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.442986+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.443009+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.443029+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.443048+08
NOTICE:  time1:2015-03-11 09:00:00.440075,time4:2015-03-11 09:00:00.44307+08
DO

该循环是一个事务，可以看出localtimestamp,now()三者记录的都是事务的开始时间，只有clock_timestamp()记录的是实时时间。

参考：http://www.07net01.com/2014/09/135111.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!