[singron]

now() is the timestamp the transaction began at. There is no function to return the commit timestamp because you have to write the value before you commit.