title: MYSQL TIMESTAMPDIFF() gives wrong value
body: <p>I'm giving input to <code>TIMESTAMPDIFF(HOUR,'29-10-2012','19-11-2012')</code> but I'm getting output as <code>504</code> but the value should be <code>510</code>.</p>
  
  <p>The output is <code>510</code> because start value is <code>29/10/2012 05:13</code>.</p>
  
  <p>Is there alternative to this function which gives Day,Hour,Minute,Second difference between two dates?</p>