使用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)
