title: DATE_FORMAT(CONVERT_TZ) coming up empty in MySQL
body: <p>Can find many instances of <code>date_format</code> OR <code>convert_tz</code> questions but none with both, so sorry if this has been asked and answered.</p>
  
  <p>Anyway... I'm coming up empty with the following query.</p>
  
  <pre><code>"SELECT... MAX(DATE_FORMAT(CONVERT_TZ(p.posted_on, 'UTC', 'America/New_York'), 
  '%e-%b-%y %l:%i %p')) AS last, MIN(DATE_FORMAT(CONVERT_TZ(p.posted_on, 'UTC', 
   'America/New_York'), '%e-%b-%y %l:%i %p')) AS first.....";
  
  Array
  (
      [thread_id] =&gt; 7
      [subject] =&gt; Sample Thread
      [username] =&gt; troutster
      [responses] =&gt; 1
      [last] =&gt; 
      [first] =&gt; 
  )
  </code></pre>
  
  <p>I can get rid of the <code>CONVERT_TZ</code> and just use <code>p.posted_on</code> by itself and it works fine, so I'm assuming I'm doing something wrong in the conversion. Thanks for any help you can provide.</p>