postgresql timestamp into code example

Example 1: postgres timestamp to datetime

to_timestamp(field_name)::timestamp

Example 2: timestamp(0) postgresql

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