title: MariaDB convert_tz maketime
body: <p>When I run this query</p>
  
  <pre><code>select convert_tz( 
      concat( 
          (`last_mailing` + interval 1 day), ' ', maketime(`email_delivery_hour`,0,0) 
            ),
      'EST','GMT') 
      FROM `member_subscriptions`
  </code></pre>
  
  <p>the date - time stamps returned include fractions of a second, such as</p>
  
  <pre><code>2014-07-01 05:00:00.000000
  </code></pre>
  
  <p>I need the date - time to return in the format</p>
  
  <pre><code>YYYY-MM-DD HH:II:SS
  </code></pre>
  
  <ul>
  <li><code>last_mailing</code> is column type datetime</li>
  <li><code>email_delivery_hour</code> is column type int(2)</li>
  </ul>