CODE EXAMPLE FOR SQL

postgres extract date from timestamp

SELECT DATE(column_name) FROM table_name;