select now(); //2017-01-17 20:43:31.946015+08
select date_trunc('second', now()); //2017-01-17 20:28:33+08
SELECT CURRENT_TIMESTAMP(0) :: TIMESTAMP WITHOUT TIME ZONE; //2017-01-17 20:28:33select now(); //2017-01-17 20:43:31.946015+08
select date_trunc('second', now()); //2017-01-17 20:28:33+08
SELECT CURRENT_TIMESTAMP(0) :: TIMESTAMP WITHOUT TIME ZONE; //2017-01-17 20:28:33