title: Compare Date/Time in SQL Server T-SQL
body: <p>We have this format Date/Time stored in a varChar column for each row in our table: 2013-05-26 20:22:07.2894.</p>
  
  <p>How can we use this column in a T_SQL WHERE statement to retrieve the last 1 hour's worth of rows?</p>
  
  <p>We have tried this and it works: WHERE Time_Stamp > '2013-05-26 18:00:00:0000' however we would like to have the T-SQL to work automatically rather than having the date/tie hard coded. </p>