select date timestamp postgres code example

Example: postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;