title: MySQL - WHERE ATD is within minus 10 minutes from STD
body: <p>first post on Stack Overflow.
  Been stuck on this issue for a few hours.</p>
  
  <p>I want to find the entries where the "Actual Time of Departure" (ATD) is within minus 10 minutes from "Schedule Time of Departure" (STD). The two fields are of the TIME format ('14:04:30'). The last request I tried was:</p>
  
  <pre><code>WHERE `ATD` &gt; `STD` - INTERVAL 10 MINUTE
  </code></pre>
  
  <p>but that doesn't work.</p>
  
  <p>Help would be appreciated.</p>