how to select today's data in postgresql code example Example: postgresql date = today Select * from table where col_date::date = now()::date;