Select date only without the hour on postgresql [duplicate]

Question

I have date column on my postgres table as timestamp format i.e "2017-01-01 22:00:00". When I wrote in the queries

select date from table where date = '2017-01-01' it did not give me any result.

Should I always include the time information on those queries? Can I just put the yyyy-mm-dd only on my queries to search the date column?

regards

Answer 1

Cast to date:

select "date" from table where "date"::date = '2017-01-01'

Note that I enclosed references to the date column in double quotes, because date is a Postgres keyword. You should avoid naming your columns, tables, or schemas using keywords.