PostgreSQL基础 time 时间类型转换

CentOS 7.6.1810
postgresql 14.4

time 时间类型转换

postgres=# select now();
              now              
-------------------------------
 2022-07-16 16:50:59.583184+08
(1 row)

postgres=# select now()::timestamp;
            now             
----------------------------
 2022-07-16 16:51:12.493966
(1 row)

postgres=# select now()::timestamp without time zone;
            now            
---------------------------
 2022-07-16 16:51:48.41618
(1 row)

postgres=# select now()::date;
    now     
------------
 2022-07-16
(1 row)

postgres=# select now()::time;
       now       
-----------------
 16:52:34.782013
(1 row)

postgres=# select now()::time with time zone;
        now         
--------------------
 16:52:45.270811+08
(1 row)

学习资料

• postgresql
• download-postgresql
• docs-postgresql
• db-engines
• 墨天轮社区

欢迎各位同学一起来交流学习心得！