title: How can query last 5 minutes of records?
body: <p>How I can to see last 5 mins record before the current time through sql query how i can do this.
  The format of time stamp is </p>
  
  <pre><code>03/25/2014 14:00:00
  </code></pre>
  
  <p>I used this query for the same </p>
  
  <pre><code>SELECT Time stamp FROM TABLE 
  WHERE S &gt;1 AND SUBSTRING((Time stamp,15,2)-5) 
  </code></pre>
  
  <p>is this fine of any other way to do the same</p>