timestamp query in postgresql code example Example 1: postgres get timestamp SELECT CURRENT_TIMESTAMP; Example 2: timestamp(0) postgresql (now())::timestamp(0))