Equivalent of PHP format('%R%a.%h'); in MySQL
<p>What is the equivalent of this function of php in mysql:</p>

<p><code>$cba=date_diff($cb,$ca);
 $cba-&gt;format('%R%a.%h');</code></p>

<blockquote>
  <p>output: Date: 1.12 //that's 1day and 12 hours</p>
</blockquote>

<p>Here's where I'm going to use it for:</p>

<p><code>DATEDIFF(q2.adate, q1.deact) AS ND,</code></p>

<p>Can i do the same process in mysql alone, Thanks</p>