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