extract date from now() code example

Example: postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;