how to select date from timestamp in postgresql code example Example: postgresql get date from datetime SELECT DATE(column_name) FROM table_name;