store the date and time in postgresql code example
Example 1: postgresql get date from datetime
SELECT DATE(column_name) FROM table_name;
Example 2: postgre query date
SELECT * FROM data WHERE date = '2020-12-21'
SELECT DATE(column_name) FROM table_name;
SELECT * FROM data WHERE date = '2020-12-21'