title: How do I compare two datetime fields in SQL Server 2005?
body: <pre><code>DECLARE  @p_date DATETIME
  SET      @p_date = CONVERT( DATETIME, '14 AUG 2008 10:45:30',?)
  
  SELECT   *
  FROM     table1
  WHERE    column_datetime = @p_date
  </code></pre>
  
  <p>I need to compare date time like:</p>
  
  <pre><code>@p_date=14 AUG 2008 10:45:30
  column_datetime=14 AUG 2008 10:45:30
  </code></pre>
  
  <p>How can I do this?</p>