title: DateDiff in SQL Server asking for help
body: <p>I am using SQL Server 2008. I have a table which has a datetime type column called CreateTime. I need to select all the records from this table whose CreateTime is more than 3 days and half an hour from current time (UTC time). I am using T-SQL store procedure.</p>
  
  <p>BTW: The CreateTime column is some time in the past time.</p>
  
  <p>I have taken quite some time to learn and search for help from MSDN for DateDiff, but cannot figure out. Could anyone show me a sample please?</p>
  
  <p>thanks in advance,
  George</p>