test=# select date_trunc('second',now())::timestamp || '.000';
?column?
-------------------------
2017-07-25 17:08:43.000
(1 Zeile)
test=# select date_trunc('second',now())::timestamp || '.000';
?column?
-------------------------
2017-07-25 17:08:43.000
(1 Zeile)