title: Select date only without the hour on postgresql
body: <p>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 </p>
  
  <p><code>select date from table where date = '2017-01-01'</code> it did not give me any result. </p>
  
  <p>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? </p>
  
  <p>regards</p>