title: Formatting and comparing two dates fields
body: <p>I'm trying to compare two dates fields while i'm so formatting it but seems not to work. the select statement works but i'm having problem with the where clause</p>
  
  <pre><code>SELECT fname
      ,lname
      ,email
      ,rdate_up = CONVERT(VARCHAR(19), GETDATE())
      ,last_time = CONVERT(VARCHAR(19), GETDATE())
  FROM my_account
  WHERE my_account.email = MMColParam
      AND rdate_up = CONVERT(VARCHAR(19), GETDATE()) &lt; last_time_log = CONVERT(VARCHAR(19), GETDATE())
  </code></pre>