title: Select DATEADD minutes with query SQL Server 2005
body: <pre><code>SELECT
     [NAMENO],
     [FIRSTNAME],
     [MIDNAME],
     [LASTNAME],
     [SEX],
     [STATUSOF],
     [RELEASEDT],
     CONVERT(VARCHAR(10), DOBDT, 101) AS DOBDT 
  FROM
     database
  WHERE 
     ReleaseDT &gt;= dateadd(minute,datediff(minute,60,GETDATE()),0)
     AND ReleaseDT &lt; dateadd(minute,datediff(minute,0,GETDATE()),0)
  </code></pre>
  
  <p>I am wanting to get anyone that has a "releasedt" in the past 60 mins if that makes of sense? right now its pull the last 60 days..</p>
  
  <p>Any suggestions??</p>