title: SQL where datetime column equals today's date?
body: <p>How can I get the records from a db where created date is today's date?</p>
  
  <pre><code>SELECT [Title], [Firstname], [Surname], [Company_name], [Interest] 
  FROM [dbo].[EXTRANET_users] 
  WHERE DATE(Submission_date) = DATE(NOW())
  </code></pre>
  
  <p>This doesn't work im using sql server 2000 and submission date is a date time field </p>