postgres timestamp to datetime code example
Example 1: postgres timestamp to datetime
to_timestamp(field_name)::timestampExample 2: postgresql today - 1 year
select now() - INTERVAL '1 YEAR';to_timestamp(field_name)::timestampselect now() - INTERVAL '1 YEAR';