使用current_timestamp在GreenPlum中生成只保留到秒域方式
qmsprd=# select current_timestamp;
now
-------------------------------
2020-09-04 13:30:35.849908+08
(1 row)
qmsprd=# select current_timestamp::timestamp(2);
now
------------------------
2020-09-04 13:30:52.15
(1 row)
qmsprd=#
qmsprd=# select current_timestamp::timestamp(0);
now
---------------------
2020-09-04 13:30:56
(1 row)