Date filteration in Postgre SQL

Question

I am looking to get the row which has the date is equal to 2017-01-12. The date has field type timestamp without time zone. I tried

SELECT * FROM tabl WHERE date = 2017-01-12;

What is the correct syntax?

Answer 1

try:

SELECT * FROM tabl WHERE date = '2017-01-12';

Answer 2

If that doesn't work, try an explicit cast:

SELECT * 
FROM tabl 
WHERE date = DATE '2017-01-12';