title: how to use date and time interval using time stamp
body: <pre><code>sample time = '07:00:00'
  Select date_add(sampletime, interval '24' HOUR), interval '20' minute) as samplefrom sample.time;
  </code></pre>
  
  <p>How could I use combination of hour and mins interval?</p>
  
  <p>or </p>
  
  <pre><code>sample datetime = '2014/01/01 07:00:00'
  </code></pre>
  
  <p>SQL Query for date hour mins computation if possible.</p>