psql convert timestamp to date code example
Example 1: postgres timestamp to datetime
to_timestamp(field_name)::timestamp
Example 2: postgresql get date from datetime
SELECT DATE(column_name) FROM table_name;
to_timestamp(field_name)::timestamp
SELECT DATE(column_name) FROM table_name;