get datetime as date postgre code example

Example: postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;