current date in postgresql + some date code example

Example: postgresql date = today

Select * from table where col_date::date = now()::date;