generic postgres timestamp code example

Example 1: postgres get timestamp

SELECT CURRENT_TIMESTAMP;

Example 2: timestamp(0) postgresql

(now())::timestamp(0))