CODE EXAMPLE FOR SQL

postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;