PostgreSQL 时间函数的比较

一白.

已于 2023-04-21 12:28:02 修改

阅读量9.2k

点赞数 1

分类专栏： PostgreSQL 基础文章标签： postgresql 时间函数

于 2015-03-11 08:20:13 首次发布

本文链接：https://blog.csdn.net/luojinbai/article/details/44193925

版权

PostgreSQL 基础专栏收录该内容

65 篇文章 19 订阅

订阅专栏

写一个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:% , time2:% , time3:% , time4:%' , localtimestamp , current_timestamp , now() , 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 , 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.442269+08
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.442291+08
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.442311+08
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.442336+08
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.442356+08
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.442376+08
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.442395+08
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.442416+08
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.442833+08
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.442881+08
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.442906+08
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.442926+08
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.442945+08
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.442965+08
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.442986+08
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.443009+08
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.443029+08
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.443048+08
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.44307+08
DO

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

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