postgres date to timestamp code example

Example 1: postgres get timestamp

SELECT CURRENT_TIMESTAMP;

Example 2: postgres timestamp to datetime

to_timestamp(field_name)::timestamp