title: How to display time at MIDNIGHT when converting "timestamptz" format to "timestamp" using "AT TIME ZONE"
body: <p>I'm converting a column of <code>timestamptz</code> format to <code>timestamp</code> using the below query:</p>
  
  <pre><code>    SELECT table.recording_datetime AT TIME ZONE 'America/New_York' FROM table;
  </code></pre>
  
  <p>This works as expected for all values except for times at midnight when it does NOT display the time. For example, a value of <code>2018-12-13 00:00:00.0000000 -05:00</code> gets converted to <code>2018-12-13</code> and not <code>2018-12-13 00:00:00</code>, as it does for other non-midnight times. Any clues to get the hour, minutes, and seconds at midnight too?</p>