title: How to get ending time last 1 hour data in mysql?
body: <p>I have below table filed in varchar datatype, I want get the last one hour data from table time using mysql query
  I have </p>
  
  <p><strong>PHP</strong></p>
  
  <pre><code>$total = (double) $input * (double) $rate;
  return number_format((double) $total, 2);
  </code></pre>
  
  <p><strong>Jquery</strong></p>
  
  <pre><code>total =  parseFloat(input) * parseFloat(rate);
  return  total.toFixed(2);
  </code></pre>
  
  <p><strong>PHP</strong></p>
  
  <pre><code>$total = (double) $input * (double) $rate;
  return number_format((double) $total, 2);
  </code></pre>
  
  <p><strong>Jquery</strong></p>
  
  <pre><code>total =  parseFloat(input) * parseFloat(rate);
  return  total.toFixed(2);
  </code></pre>