title: mysql Time Difference Query
body: <p>I have a query where I have to calculate the time difference in minutes but I need seconds as well. So, can I use 6.10 stating 6 minutes 10 seconds in the following query? OR is there any alternative to state this?</p>
  
  <p>Query:</p>
  
  <pre><code>select distinct(users) , avisitedDate from visitSearchEngine vs
  WHERE vs.users!=' ' 
  AND vs.status='0' 
  AND vs.hitType='googleIdentified'
  AND vs.avisitedDate&gt;'2012-12-06' 
  AND ((TIME_TO_SEC(TIMEDIFF(NOW(),vs.avisitedDate)))/60)&gt;=5
  AND ((TIME_TO_SEC(TIMEDIFF(NOW(),vs.avisitedDate)))/60)&lt;6.10
  </code></pre>
  
  <p>Please provide me suggestions! </p>
  
  <p>Thanks,</p>