postgresql 获取日期时间的方法

最新推荐文章于 2024-08-21 17:53:06 发布

数据库人生

最新推荐文章于 2024-08-21 17:53:06 发布

阅读量6.5k

点赞数

分类专栏： # postgresql sql plpgsql 文章标签： CURRENT_DATE CURRENT_TIME now() transaction_timestamp() clock_timestamp()

本文链接：https://blog.csdn.net/ctypyb2002/article/details/81199144

版权

postgresql sql plpgsql 专栏收录该内容

46 篇文章 4 订阅

订阅专栏

获取当前事务的日期和/或时间∶

CURRENT_DATE
CURRENT_TIME
CURRENT_TIME (precision)
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP (precision)

LOCALTIME
LOCALTIME (precision)
LOCALTIMESTAMP
LOCALTIMESTAMP (precision)

now()
transaction_timestamp()

$ psql 
psql (9.1.24)
Type "help" for help.

postgres=# select now();
              now              
-------------------------------
 2018-07-25 11:15:26.238933+08
(1 row)

postgres=# begin;
BEGIN
postgres=# \x
Expanded display is on.
postgres=# select current_date,
                  current_time,
				  current_time(6),
				  current_timestamp,
				  current_timestamp(6),
				  localtime,
				  localtime(6),
				  localtimestamp,
				  localtimestamp(6),
				  now(),
				  transaction_timestamp();
-[ RECORD 1 ]---------+------------------------------
date                  | 2018-07-25
timetz                | 11:15:33.138884+08
timetz                | 11:15:33.138884+08
now                   | 2018-07-25 11:15:33.138884+08
timestamptz           | 2018-07-25 11:15:33.138884+08
time                  | 11:15:33.138884
time                  | 11:15:33.138884
timestamp             | 2018-07-25 11:15:33.138884
timestamp             | 2018-07-25 11:15:33.138884
now                   | 2018-07-25 11:15:33.138884+08
transaction_timestamp | 2018-07-25 11:15:33.138884+08

获取当前实时时间

statement_timestamp()
clock_timestamp()
timeofday()

postgres=# select statement_timestamp(),clock_timestamp(),timeofday();
-[ RECORD 1 ]-------+------------------------------------
statement_timestamp | 2018-07-25 11:19:03.633837+08
clock_timestamp     | 2018-07-25 11:19:03.634195+08
timeofday           | Wed Jul 25 11:19:03.634203 2018 CST