title: How to get the end of a day?
body: <p>I'm using <code>PostgreSQL 8.4</code>. I have a column of the table <code>my_tbl</code> which contains dates (<code>timestamp without timezone</code>). For instance:</p>
  
  <pre><code>       date
  -------------------
  2014-05-27 12:03:20
  2014-10-30 01:20:03
  2013-10-19 16:34:34
  2013-07-10 15:24:26
  2013-06-24 18:15:06
  2012-07-14 07:09:14
  2012-05-13 04:46:18
  2013-01-04 21:31:10
  2013-03-26 10:17:02
  </code></pre>
  
  <p>How to write an SQL query which returns all dates in the format:</p>
  
  <pre><code>xxxx-xx-xx 23:59:59
  </code></pre>
  
  <p>That's every date will be set to the end of the day.</p>