title: How to set time in query in postgres
body: <p>I have a query in which i want to select records for a single day only. like b/w '00:00:00' to '23:59:59'.</p>
  
  <p>for example if user select data and time(2016-06-27 10:40) then my query would be like:</p>
  
  <pre><code> select * from users where logtime between ? and '2016-06-27 23:59:59' // logtime is a timestamp
  </code></pre>
  
  <p>As per requirement on html page i only need to give an option that user can select a single date and time and then submit a search. I am confusing that in a sql query how i can append a end date(whatever date user select) and time(always be 23:59:59).
  Can someone give me idea is there any postgres function which can help to extract a date from given date and append time(23:59:59) and return a datetime ?</p>