Date in Postgresql is represented in a YYYY-MM-DD format. SELECT * FROM data WHERE date = '2022-03-14'