postgresql date now code example
Example 1: postgresql date = today
Select * from table where col_date::date = now()::date;
Example 2: postgre query date
SELECT * FROM data WHERE date = '2020-12-21'
Select * from table where col_date::date = now()::date;
SELECT * FROM data WHERE date = '2020-12-21'